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

Scripts by Peter Samson profile

   Items 1 to 2 of 2   

See the compile time

Useful if you think a SQL statement, Function, or SPROC is taking too long to compile.  Read more...
By Peter Samson 2010/02/23 | Source: | Category: performance tuning
Rating: |  Discuss |   Briefcase | 948 reads

Index Seeks, Scans, and Lookups

This script may help identify tables impacted by frequently-occurring scans.  Read more...
By Peter Samson 2010/11/02 | Source: | Category: indexing
Rating: |  Discuss |   Briefcase | 3,724 reads
   Items 1 to 2 of 2