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

Scripts by sql frenzy

SQLServerCentral.com 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: SQLServerCentral.com | Category: sp_who2
Rating: |  Discuss |   Briefcase | 2,325 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: SQLServerCentral.com | Category: table
Rating: |  Discuss |   Briefcase | 1,606 reads

Aggregating Index usage information

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