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 in SQL Server. However many people don't understand how indexes work and why they are important. MVP Gail Shaw provides us with an introductory article to explain 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...

Just today, I was reviewing the indexing of a database used by a third-party application. As part of my review, I ran a script against it that is used to identify duplicate indexes. The script I used was written Paul Nielsen, the author of the SQL Server...  Read more...

There are certain requirements for creating indexes on computed columns and this tip shows you want needs to be done.  Read more...

Indexes are critical to good performance in SQL Server. However many people don't understand how indexes work and why they are important. MVP Gail Shaw provides us with an introductory article to explain the basics of indexing.  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...

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