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

Content with tags Maintenance, Indexing Rss

<< Newer    Items 21 to 32 of 32   
 

2008 Index Fragmentation Maintenance

Just a stab at automating index maintainenance in SQL Server 2008  Read more...
By Grant Fritchey 2013/01/11 | Source: SQLServerCentral.com | Category: fragmentation
Rating: |  Discuss |   Briefcase | 2,496 reads

Reindex all indexes online or offline depending on day of week.

This script will reindex (online) any index eligible to be reindexed online. Accepts a day of week parameter for full offline reindexing.   Read more...
By Kenneth Singer 2011/04/18 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 4,404 reads

The Ultimate Prospective-Index Column(s) Selectivity Analyzer

Gets single-column and cumulative-column selectivity stats and @Top largest dupe sets for each cumulative column stepping for a set of one or more columns for a table.  Read more...
By Jesse Roberge 2008/10/24 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,058 reads

The Ultimate Duplicate Index Finder

Searches database-wide for multiple indexes in the same table which has the same column as the first seek key. Optionally limits to LIKE wildcard patterns of table and schema names.  Read more...
By Jesse Roberge 2008/10/17 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,970 reads

disable/enable indexes for table

This procedure disables or rebuilds indexes for a given tablename  Read more...
By Wilfred van Dijk 2008/10/16 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 1,380 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 2012/12/27 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 7,460 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,407 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,569 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,586 reads

Check Fragmentation on All Indexes on Database

In this script we create a temporal table and then review all indexes with next conditions. avg_fragmentation_in_percent > 10 % or avg_page_space_used_in_percent > 90 %   Read more...
By Augusto Alfonso 2008/09/03 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 4,303 reads

SQL Server 2005 Index Maintenance

Index maintenance procedure using rebuild or reorganized based on fragementation level.  Read more...
By Luke Campbell 2011/10/26 | Source: SQLServerCentral.com | Category: maintenance
Rating: |  Discuss |   Briefcase | 3,333 reads

Script foreign keys

Using this script you can create a list of sql commands for foreign keys manipulation.  Read more...
By Boka 2012/01/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,650 reads
<< Newer    Items 21 to 32 of 32   
 
Tags
sql server 2005 (11)    
administration (9)    
maintenance and management (9)    
performance tuning (8)    
t-sql (8)    
utility (7)    
list indexes (5)    
pivot (5)    
sys.dm_db_partition_stats (5)    
crosstab (4)    
for xml path (4)    
fragmentation (2)    
automation (1)    
defragment (1)    
duplicate indexes (1)    
log file maintenance (1)    
management (1)    
missing indexes (1)    
rebuilding indexes (1)    
reindex (1)    
selectivity (1)    
sql server 2008 (1)    
sys.dm_db_index_usage_stats (1)    
sys.dm_db_missing_index_details (1)    
tuning (1)