Moving Tables and Indexes to Filegroups En Masse

Longtime author and SQL Server expert David Poole brings us a method to

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.

Obtaining Index Usage Information

This article shows how the sys.dm_db_index_usage_stats DMV can be used to tune your indexes, and maximize the performance of your database

Disabling Indexes - SQL School Video

There are times that you do not want indexes to be updated and used. Brian Knight shows how you can accomplish this with a new SQL School video.

Finding a better candidate for your clustered indexes

When creating tables it is difficult to determine exactly how the data will be accessed. Therefore when clustered indexes are chosen they are often just the ID column that makes the row unique. This may be a good choice, but once the application has been used and data access statistics are available you may need to go back and make some adjustments to your tables to ensure your clustered indexes are providing a benefit and not a drain on your applications.

Indexes

Analyze and Fix Index Fragmentation in SQL Server 2008

This article describes how an index gets fragmented and the steps which a DBA can take to fix index fragmentation

Getting unique or primary key columns for a given table

Following script will list out all the columns which have unique/primary key constraints for a given table.

Using SQL Server DMVs to Identify Missing Indexes

I can run the Database Tuning Advisor or examine the query plans, but is there any easier way to determine which indexes may be needed?

SQL Server Index Basics

Given the fundamental importance of indexes in databases, it always comes as a surprise how often the proper design of indexes is neglected. It often turns out that the programmer understands detail, but not the broad picture of what indexes do. Bob Sheldon comes to the rescue with a simple guide that serves either to remind or educate us all!