Top 10 steps to optimize data access in SQL Server. Part I (Use Indexing)

’ll focus on the issues that you need to follow to make sure that you have done everything that you could do to optimize the data access codes you have written or you are going to write in future. The Database Administrators (DBA) also has great roles to play in optimizing and tuning the database performance. But, optimization scopes that fall into a DBA’s area are out of scope for these articles.

Full Text Index Management in SQL Server 2005 Express Edition

Recent installments of our series dedicated to the most important features of SQL Server 2005 Express Edition have focused on its Full Text Indexing capabilities. This article covers other full text indexing management methods.

Clustered Index Internals

Find botched constraints, idxs, fks

Shows awesome view of columns with constraints and indexes and foreign keys to spot errors fast.

Index Defragmentation

Index Defragmentation is one of the most important DBA tasks. This will significantly improve query performance.

Introduction to Indexes: Part 3 – The nonclustered index

Part 3 of a great series on the basics of indexes. Learn the structure, definition, and how to examine the use of these indexes in your queries.

Introduction to Indexes: Part 2 – The clustered index

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.

An Un-indexed Foreign Key Gotcha

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.

Index Primer - Just what statistics are kept?

An in-depth look at index statistics and how they are used by the optimizer by Josef Richberg.

Introduction to Indexes

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.