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

Content with tags Maintenance and Management, Indexing Rss

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

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,406 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,567 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 | 18,552 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,324 reads
<< Newer    Items 21 to 40 of 82    Older >>
 
Tags
miscellaneous (29)    
t-sql (24)    
sqlinsider scripts (16)    
administration (10)    
maintenance (9)    
sql server 2005 (9)    
performance tuning (8)    
utility (8)    
backup / 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)