Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Indexing, Maintenance and Management Rss

<< Newer    Items 21 to 40 of 83    Older >>
 

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 2012/12/27 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 7,618 reads

The Ultimate Index Lister (Pivoted)

Lists details for all indexes on one or more tables / schemas, including row count and size. This version outputs the member seek + include columns as two comma separated output columns.  Read more...
By Jesse Roberge 2008/10/09 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,433 reads

The Ultimate Index Lister (Non-Pivoted)

Lists details for all indexes on one or more tables / schemas, including row count and size. The non-pivot version also gives data type and other details for the columns.  Read more...
By Jesse Roberge 2013/10/02 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 3,596 reads

The Ultimate Missing Index Finder

Reports stats on what the query optimizer records in the DMVs as missing indexes and what it says the cost savings will be if they were present. Can limit by table / schema name patterns.  Read more...
By Jesse Roberge 2013/01/07 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 19,052 reads

Get all user def table info

Get space for all user defined table information like size and row counts.  Read more...
By Mohit Nayyar 2013/12/27 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 7,378 reads
<< Newer    Items 21 to 40 of 83    Older >>
 
Tags
miscellaneous (29)    
t-sql (24)    
sqlinsider scripts (16)    
administration (10)    
maintenance (9)    
sql server 2005 (9)    
performance tuning (8)    
utility (8)    
backup and restore (7)    
list indexes (5)    
pivot (5)    
sys.dm_db_partition_stats (5)    
crosstab (4)    
data warehousing (4)    
for xml path (4)    
lock and connection management (4)    
replication (3)    
mail (2)    
defragmentation (1)    
duplicate indexes (1)    
foreign keys (fk) (1)    
log file maintenance (1)    
management (1)    
missing indexes (1)    
search (1)    
selectivity (1)    
sys.dm_db_index_usage_stats (1)    
sys.dm_db_missing_index_details (1)    
tables (1)