SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
Home Articles Editorials Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us


 

Scripts with tags Administration, Index Usage Rss

Refine your search with one of the following additional tags (with number of items):

Index Management (2)     Maintenance (2)     SQL Server 2005 (2)     Crosstab (1)    
Indexes (2)     Maintenance and Management (2)     T-SQL (2)     FOR XML PATH (1)    
Indexing (2)     Performance Tuning (2)     T-SQL Aids (2)     sys.dm_db_index_usage_stats (1)    
List Indexes (2)     pivot (2)     Utility (2)     sys.dm_db_partition_stats (1)    

Search for any content tagged Administration & Index Usage

Add a script

   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,157 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 | 4,724 reads
   Items 1 to 2 of 2   
 
 
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use