Part 3 of a great series on the basics of indexes. This time MVP Gail Shaw examines the non-clustered index. Learn the structure, definition, and how to examine the use of these indexes in your queries.  Read more...

In the second part of her series on indexing, MVP Gail Shaw examines clustered indexes. Learn what this index is, how it differs from a heap, and how it can help your queries.  Read more...

Indexing is important for improving performance, but do you know that a lack of indexes might actually cause things to stop working? Alok Dwivedi brings us a very interesting scenario where the lack of an index causes a problem with concurrency.  Read more...

Indexes are critical to good performance. However many people don't understand how indexes well. MVP Gail Shaw provides us with an introductory article on the basics of indexing.  Read more...

This article demonstrates an Index Management strategy to tackle day to day performance issues due to improper indexes.  Read more...

In continuing with our series of tips on Best Practices for SQL Server I'm turning my sights on Maintenance. Specifically in this tip we will be discussing Index maintenance: when, if, why, and how are questions that will be addressed.  Read more...

Routine maintenance can keep index fragmentation to a minimum—with some help from an index-defragmenting script.  Read more...

Read more...

Following code snippet will selectively rebuild indexes that have been thrashed after a big indert  Read more...

When created and maintained correctly, indexes help SQL Server retrieve data quickly. See how to ensure your SQL Server environment is running up to speed.  Read more...

Read more...

In this, the third of the four part series on persisting the rowset results from the indexing Dynamic Management Views cached in temporary internal SQL Server structures we will explore what is required to store the missing index-related metadata.  Read more...

The Microsoft SQL Server 2008 database software provides table partitioning to make such operations more manageable.  Read more...

New author Nilav Ghosh brings us a performance tuning article to help your queries run better. This article examines how indexes can help reduce blocking.  Read more...

Read more...

Read more...

Finds the largest dupe-sets of one or more columns of a single table or derived table. Great for finding hoggy parameter combinations for perf-testing queries within stored procedures!  Read more...

In this three-part series I'll look at what you can do to persist this data so you don't find yourself waiting for usage stats to compile over a reasonable period of time just so you can harness the power of the indexing DMOs in your performance tuning process.   Read more...

This stored procedure will reindex indexes based on the fragmentation lever.  Read more...

This article describes different ways of improving the performance of SQL Server queries, with a focus on index optimization.  Read more...

Indexes are critical to good performance. However many people don't understand how indexes well. MVP Gail Shaw provides us with an introductory article on the basics of indexing.  Read more...

In the second part of her series on indexing, MVP Gail Shaw examines clustered indexes. Learn what this index is, how it differs from a heap, and how it can help your queries.  Read more...

Part 3 of a great series on the basics of indexes. This time MVP Gail Shaw examines the non-clustered index. Learn the structure, definition, and how to examine the use of these indexes in your queries.  Read more...