By Shaunt Khaldtiance, 12/14/2009
By Shaunt Khaldtiance, 09/03/2009
SQL Server Management Studio (SSMS) doesn't have a GUI that lets you easily obtain information about partitioned tables. Here's a stored procedure that helps fill this gap.
By Shaunt Khaldtiance, 05/12/2009
Storing SQL Server Integration Services (SSIS) packages under a well-defined folder structure in msdb is advantageous, but getting them there can be a hassle. Here's a solution ...
By Shaunt Khaldtiance, 04/09/2009
Looking for an object in a SQL Server instance without knowing the object's exact name and the database in which it resides can be time-consuming. Here's a T-SQL stored procedure ...
By Shaunt Khaldtiance, 10/30/2008
The SpaceUsedAnalyzer stored procedure provides detailed information on how much space is being used by tables and their indexes so that you can manage disk space more efficiently.
By Shaunt Khaldtiance, 09/29/2008
Here's a T-SQL stored procedure that you can use to identify tables without indexes, indexes that aren't being used, and indexes that aren't being used efficiently.