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

Scripts with tag Index Management Rss

Search for any content tagged index management

Add a script

   Items 1 to 20 of 101    Next 20 >>
 

The Ultimate Index-Less Foreign-Key Finder

Searches for foreign key constraints that don't have fully matching indexes. The best partial matching indexes are outputted with MatchCounts and column comparisons.  Read more...
By Jesse Roberge 2009/10/15 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |  Briefcase | 875 reads

Shrink Log File to Target Percentage

Performs a checkpoint or a transaction log backup followed by a DBCC SHRINKFILE on the transaction log to the target percentage specified relative to the total data file(s) size.  Read more...
By Tommy Bollhofer 0001/01/01 | Source: SQLServerCentral.com | Category: maintenance
Rating: |  Discuss |  Briefcase | 1,230 reads

SQL 2005 Rebuild\Reorganize Indexes with Reports

This custom sp rebuilds \ reorganizes indexes for SQL 2005 databases and logs results for further analysis.  Read more...
By Farhan Sabzaali 2009/03/16 | Source: SQLServerCentral.com | Category: rebuild index
Rating: |  Discuss |  Briefcase | 4,701 reads

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,286 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 2008/11/12 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: (not yet rated) |  Discuss |  Briefcase | 2,505 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 2008/10/06 | Source: SQLServerCentral.com | Category: index management
Rating: |  Discuss |  Briefcase | 12,266 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: index management
Rating: |  Discuss |  Briefcase | 1,863 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: index management
Rating: |  Discuss |  Briefcase | 2,351 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,069 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 2008/10/07 | Source: SQLServerCentral.com | Category: index management
Rating: |  Discuss |  Briefcase | 2,401 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: index management
Rating: |  Discuss |  Briefcase | 1,925 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: index management
Rating: |  Discuss |  Briefcase | 3,238 reads

usp_IndexesUnused - SQL 2k5

Checks index usage  Read more...
By Pedro Lopes-389536 2008/06/24 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |  Briefcase | 1,897 reads

SQL 2005 IndexDefrag solution

Manual SP to Index Defrag a SQL 2000 database on SQL 2005 that run at spesific times at night  Read more...
By Kobus-452994 2008/06/19 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |  Briefcase | 2,532 reads

SQL Server 2005 & 2008 - Backup, Integrity Check & Index Optimization

Solution for Backup, Integrity Check and Index Optimization in SQL Server 2005 and SQL Server 2008. Updated 06 Dec 2009.  Read more...
By Ola Hallengren 0001/01/01 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |  Briefcase | 24,389 reads

Generate index on foreign key columns

Script find all foreign key without index in database and create new one for them.  Read more...
By tklimczak 2008/03/04 | Source: SQLServerCentral.com | Category: index management
Rating: |  Discuss |  Briefcase | 1,470 reads

2005 Unused indexes v2

Better script for determining unused indexes  Read more...
By Wilfred van Dijk 2008/02/21 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |  Briefcase | 1,643 reads

Script foreign keys

Using this script you can create a list of sql commands for foreign keys manipulation.  Read more...
By Boka 2008/01/08 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 2,606 reads

2005 unused indexes

Shows unused indexes compared to nr of modifications  Read more...
By Wilfred van Dijk 2007/12/18 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |  Briefcase | 2,084 reads

usp_IndexCreationStatements

(SQL 2005) Creates Index Creation statements based on info colected in system view sys.dm_db_missing_index_details, either with included columns or just In(Equality) columns.  Read more...
By Pedro Lopes-389536 2007/12/13 | Category: sql server 2005
Rating: (not yet rated) |  Discuss |  Briefcase | 884 reads
   Items 1 to 20 of 101    Next 20 >>