Scripting CREATE INDEX Statements Automatically From Your Tables

Stored proc for scripting out full CREATE INDEX statements from your table indexes with all filegroup, filter and WITH parameters.

Intelligent Index Reorganize and Rebuild Script - v1.0

This script will provide a dynamic mechanism to decide between REBUILDING an index or simply REORGANIZING an index. Tested and approved for SQL Server 2005 & 2008 Standard or Enterprise or R2.

Script for no of Index in a table

This script will tell you how many indexes there are for a single table and also it specifically shows how many non clustered index, and also which tables have a heap index.

Index types 2

Index types 1

2008 Index Rebuild using DMV

Index Maintenance procedure with HTML Reporting capabilities. Please refer to attached script for detailed information.

Index Types

Rebuilding SQL Server indexes using the ONLINE option

As each year goes by the uptime requirement for our databases gets larger and larger, meaning the downtime that we have to do maintenance on our databases is getting smaller and smaller. This tip will look at a feature that was introduced in SQL Server 2005 that allows us to leave our indexes online and accessible while they are being rebuilt.

Indexing - Take the Hint and Leave it to the Experts

The most common T-SQL command in use has to be the SELECT statement, it is the bedrock of any SQL Professional's day. Sometimes it's used to snatch some data from a table or two while some quick investigation is done, other times it is at the heart of a stored procedure or view that will inform business decisions for coming months or even years.

Query Tuning