Tables, Queues, and Indices as a Percent of DB Size

Two views that give you a variety of stats, sortable as a percent of DB size, for tables, indiceses, XML indices, and Service Broker Queues.

usp_IndexesUnused - SQL 2k5

Checks index usage

SQL 2005 IndexDefrag solution

Manual SP to Index Defrag a SQL 2000 database on SQL 2005 that run at spesific times at night

Using Indexes to Bypass Locks

One of the issues you'll face with SQL Server is blocking which is caused by other processes that are holding locks on objects. Until the locks are removed on an object the next process will wait before proceeding. This is a common process that runs within SQL Server to ensure data integrity, but depending on how transactions are run this can cause some issues. Are there ways to get around blocking by using different indexes to cover the queries that may be running?

Discuss content posted by Sameeksha

Discussions about content posted by Sameeksha

SQL Server Index Checklist

Indexing a SQL Server database in some respects is considered both an art and a science. Since this is the case, what are some considerations when designing indexes for a new database or an existing one in production? Are these the same types of steps or not? Do any best practices really exist when it comes to indexing? Where does indexing fall in the priority list from an application or production support perspective?

SQL Server 2005 Index Maintenance

Index maintenance procedure using rebuild or reorganized based on fragementation level.

Statistics and Indexes

When is it okay to let SQL Server to make a statistic for columns in your queries, and when should you take those statistics and make an index out of them? What I do is to test all of my procs, and if they generate system statistics (_WA_SYS%), then I add an index to the table for the column in the statistic. But is this a good practice?

Statistics

SQL Server non-clustered indexes for query optimization

Optimize SQL Server non-clustered indexes and queries by considering index fields, compound indexes and SQL Server statistics' impact on non-clustered indexes.