Using a Clustered Index to Solve a SQL Server Deadlock Issue

At some time or another every DBA has been faced with the challenge of solving a deadlock issue in their SQL Server database. In the following tip we will look at how indexes and more specifically clustered indexes on the right columns can help reduce the chance of your applications receiving this dreaded error

Indexes

SQL Server Index Statistics

Are your index statistics up to date? The SQL Server database engine uses statistics to determine which execution plan to use when a query is compiled. Index statistics are used to help the SQL Server engine determine the cardinality of different column values in a SQL Server table. If you want to give SQL Server a fighting chance at picking an optimal execution plan then you need to make sure you maintain your index statistics.

Are remote databases fragmented? Let's Defrag.

This article shows an automated reorg/rebuild index for remote servers with notifications for the DBA.

List all tables without LOB columns

Lists all the tables in a database that do not contain any LOB columns(text, ntext, image, varchar (max), nvarchar (max), varbinary (max) and xml).

Useful when rebuilding indexes online.

Page split - 2

Speeding Up Database Access Part 3 - Fixing Missing Indexes

Learn how to add those indexes you need in part 3 of Matt Perdeck's 8 part series on improving data access. This is based on the book ASP.NET Site Performance Secrets.

Speeding up Data Access Part 1 - Missing Indexes

In the first part of this series, learn how to pinpoint missing indexes in your databases.

Reindex - Reorganize or Rebuild

In the first time you execute this procedure, might take a long time, but not in the next time. Later you can execute this procedure daily.

Indexes, Indexes, Indexes

This article has a description of an index utilization tool that Ron Johnson uses to analyze the effectiveness and use of indexes in a system.