Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by SQLSACT

SQLServerCentral.com profile

   Items 1 to 3 of 3   
 

Check Backups

Checking Backups on your SQL Server  Read more...
By SQLSACT 2013/02/13 | Source: SQLServerCentral.com | Category: backups
Rating: |  Discuss |   Briefcase | 1,728 reads

Find Single use plans in Plan Cache

This script will return all the Adhoc Single use Plans currently in your Plan Cache. It also excludes Plan Shells created from auto/forced parameterization. Works for 2005/2008   Read more...
By SQLSACT 2012/12/11 | Source: SQLServerCentral.com | Category: plan cache
Rating: |  Discuss |   Briefcase | 689 reads

List all tables without LOB columns

Lists all the tables in a database that do not contain any LOB columns(text, ntext, image, varchar (max), nvarchar (max), varbinary (max) and xml). Useful when rebuilding indexes online.  Read more...
By SQLSACT 2011/08/30 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 705 reads
   Items 1 to 3 of 3