SQL Clone
SQLServerCentral is supported by Redgate
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 
By SQLSACT 2013/02/13 | Source: SQLServerCentral.com | Category: backups
Rating: |  Discuss |   Briefcase | 1,954 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 | 752 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 | 733 reads
   Items 1 to 3 of 3