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

Scripts by sql frenzy profile

   Items 1 to 3 of 3   

View connection and Locking Information

This script combines sp_who2 and sp_lock to get meaning full info that includes host Ip address   Read more...
By sql frenzy 2010/05/17 | Source: | Category: sp_who2
Rating: |  Discuss |   Briefcase | 2,406 reads

Estimating the table size...

This is an effort to program the "Estimating the Table size" section given in BOL.   Read more...
By sql frenzy 2009/07/02 | Source: | Category: table
Rating: |  Discuss |   Briefcase | 1,662 reads

Aggregating Index usage information

This script aggregates index usage stats into a view.  Read more...
By sql frenzy 2008/11/25 | Source: | Category: indexing
Rating: |  Discuss |   Briefcase | 1,264 reads
   Items 1 to 3 of 3