SQL Server Central: Content tagged SQL Server 2005, Index Management

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 2005

Rating: (not yet rated) |

Discuss |

Briefcase | 40 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: (not yet rated) |

Discuss |

Briefcase | 326 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: (not yet rated) |

Discuss |

Briefcase | 312 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: (not yet rated) |

Discuss |

Briefcase | 610 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 | 614 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: (not yet rated) |

Discuss |

Briefcase | 744 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 | 1,793 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. Read more...

By Ola Hallengren 0001/01/01 | Source: SQLServerCentral.com | Category: Backup / Restore

Rating:

|

Discuss |

Briefcase | 7,873 reads

usp_IndexesUnused - SQL 2k5

Checks index usage Read more...

By Pedro Lopes 2008/06/24 | Source: SQLServerCentral.com | Category: Administration

Rating:

|

Discuss |

Briefcase | 1,205 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 2008/06/19 | Source: SQLServerCentral.com | Category: Indexing

Rating:

|

Discuss |

Briefcase | 1,436 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. Read more...

By Ola Hallengren 0001/01/01 | Source: SQLServerCentral.com | Category: Backup / Restore

Rating:

|

Discuss |

Briefcase | 7,873 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 2007/12/13 | Category: SQL Server 2005

Rating: (not yet rated) |

Discuss |

Briefcase | 670 reads

2005 Online Index Rebuild using DMV

Identifies indexes with average logical fragmentation >= 30% using the DM available in MSSQL 2005. Please refer to script for more information. Read more...

By Tommy Bollhofer 2007/12/11 | Source: SQLServerCentral.com | Category: SQL Server 2005

Rating:

|

Discuss |

Briefcase | 2,177 reads

Index related DMVs and DMFs - sys.dm_db_index_usage_stats

Examining statistics of indexes is useful for optimizing the performance of queries. Statistics help us determine the usage and worth of indexes - one simple method is using the index-related dynamic management view; sys.dm_db_index_usage_stats Read more...

By Additional Articles 2007/11/12 | Source: SQL Server Performance | Category: SQL Server 2005

Rating: (not yet rated) Rate this |

Briefcase | 1,556 reads

Featured Blog: What happens to non-clustered indexes when the table structure is changed?

Paul Randal, former SQL Server Storage Engine lead, brings us a great explanation of how indexes are affected when you alter your schema. Read more...

By Additional Articles 2007/10/31 | Source: SQLskills | Category: SQL Server 2005

Rating: (not yet rated) Rate this |

Briefcase | 2,553 reads

Content with tags SQL Server 2005, Index Management

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