Covered Indexes Archives

Index Overview – Clustered and Nonclustered

By SteveStedman Posted on April 24, 2013 Posted in Performance No Comments Tagged with Additional Index Resources, Clustered Indexes, Covered Indexes, Database Health Reports, Index Usage Terminology, Non Clustered, Non Clustered Indexes, SQL Server

This is intended as a brief overview of indexing on SQL Server. Understanding and using indexes can lead to some major performance improvements. Non-Clustered Indexes Non-Clustered indexes are often times considered traditional indexing – contains pointers to the data. This …

Index Overview – Clustered and Nonclustered Read more »

Indexing Presentation – The Basics

By SteveStedman Posted on April 27, 2010 Posted in Performance No Comments Tagged with Additional Topics, Clustered Indexes, Covered Indexes, Determining Index Usage, Index Usage Terminology, Indexing Overview, Indexing Overview Presentation, Non Clustered Indexes

Attached is the slide deck for a short presentation on indexing that was created to educate software developers on the basics of indexing. Outline: What is an Index Types of Indexes Non Clustered Indexes Clustered Indexes When To Avoid A …

Indexing Presentation – The Basics Read more »

Tag: Covered Indexes

Index Overview – Clustered and Nonclustered

Indexing Presentation – The Basics

Login