Indexes are fundamental to database design, and tell the developer using the database a great deal about the intentions of the designer. Unfortunately indexes are too often added as an afterthought when performance issues appear. Here at last is a simple series of articles that should bring any database professional rapidly 'up to speed' with them   Read more...

For those of you that don’t know DTA stands for Database Engine Tuning Adviser and is available from the Tools...  Read more...

This one's a gimme, but an underrated utility script when I enter a new environment and look for low-hanging fruit...  Read more...

Now we have discussed about different types of indexes in the last posts. In this post, let us discuss about...  Read more...

Indexes are the database objects that enable SQL Server to satisfy each data access request from a client application with the minimum amount of effort, resulting in the maximum performance of individual requests while also reducing the impact of one request upon another. Prerequisites: Familiarity with the following relational database concepts: Table, row, primary key, foreign key  Read more...

Drop indexes no longer being used.  Read more...

Read more...

Script to reorganize all indexes on all tables in user databases  Read more...

Seldom has a SQL Server Service pack had such an effect on database development as when SQL Server 2012 SP1 introduced selective XML indexes. These transform the practicality of querying large amounts of XML data. Seth Delconte demonstrates how and why this feature makes all the difference.   Read more...

In earlier installments of this series we looked at T-SQL Performance optimizations along with different T-SQL practices, we can now turn our attention to the second part of this series which is index Tuning  Read more...

Now that we've seen the basics of indexing, and taken a deeper dive into Nonclustered Indexes, this Level will focus on searching the table, which will, in turn, will lead us to a discussion of clustered indexes.  Read more...

Just a stab at automating index maintainenance in SQL Server 2008  Read more...

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

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...

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...

A couple years back, I wrote a few blog posts about an indexing script that I use with clients from...  Read more...

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

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.  Read more...

Today Steve Jones reminds us that we should analyze and re-evalute our indexing strategy on a regular basis.  Read more...

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.  Read more...