PowerShell Solutions - Several tips for daily tasks

In this tip, we will talk about PowerShell and SQL Server Log and Data Files.

Index Breakdown

Provides a robust breakdown of all indexes contained within a database allowing for quick analysis and identification of inefficient, redundant, unused, bloated, stale, and / or poorly architected indexes.

Database size trending with powershell

a script to import all database sizes from a list of servers into a table using powershell for trending purposes

YOU MUST DOWNLOAD CODEPLEX SQL SERVER MODULE FOR THIS TO WORK.

Disk Capacities

Provides information on the total and used space for all drives on an instance.

Table Data Sizes

Script to display how the data is broken up between the tables.

Estimating the table size...

This is an effort to program the "Estimating the Table size" section given in BOL.

Database Growth History

This script uses the backup tables to get info on the growth of your database files.

Creating Installer w/ MSDE: Need to start server for OSQL

I have an installer package that installs MSDE, MDAC, etc for the client. I also need to run an SQL package to load the database. What I need to do is start the local MSDE so that I can run the following batch file:The OSQL will not run after the MSDE installation unless the PC […]

RE: Question of the Day for 10 Sep 2004

To  Rudy KomacsarOnly thing you need to do from second query analizer is to runselect * from #tempat the end of your exercises. You'll get error, because there is no table #temp for the second session. You can create it and than check  tempdb..sysobjects. It will contain 2 tables #Temp_...__<Number>, 1 per session. 

RE: User permissions

Permissions are stored in the sysprotects system table in each database. The Action column defines what type of permission (SELECT/UPDATE/CREATE TABLE/etc) is being set. Read SQL BOL for more details about the columns, but basically you should be able to select from that table with a CASE statement to see what permissions are set.CREATE TABLE, […]