SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL Aids, Maintenance and Management, Index Usage Rss

   Items 1 to 2 of 2   
 

The Ultimate Index Width Stats Reporter

Reports index length stats for indexes who's lengths exceeding parametrized thresholds (defaults to 0 - get all) for total length and seek length, optionally filtering schemas and tables.  Read more...
By Jesse Roberge 2009/01/28 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 1,288 reads

The Ultimate Index Usage Reporter

Reports index stats, index size+rows, member seek + include columns as two comma separated output columns, and index usage stats for one or more tables and/or schemas.  Read more...
By Jesse Roberge 2008/10/13 | Source: SQLServerCentral.com | Category: index management
Rating: |  Discuss |  Briefcase | 5,074 reads
   Items 1 to 2 of 2   
 
Tags
administration (2)    
index management (2)    
indexes (2)    
indexing (2)    
list indexes (2)    
maintenance (2)    
performance tuning (2)    
pivot (2)    
sql server 2005 (2)    
t-sql (2)    
utility (2)    
crosstab (1)    
for xml path (1)    
sys.dm_db_index_usage_stats (1)    
sys.dm_db_partition_stats (1)