Extra-Wide Covering Indexes

 

Extra-Wide Covering Indexes
Watch Extra-Wide Covering Indexes Download Extra-Wide Covering Indexes

Description

  SQL Server indexes are constrained to a maximum width of 900 bytes. In this video you'll learn how to get around that limit using T-SQL in order to create indexes that can be used for a wide variety of performance purposes - including 'extra wide' covering indexes.

This Video Covers

Indexes, the SQL Server Storage Engine, and T-SQL tips and tricks.

Details

Length: 07:55

Skill Level: 400 - Guru.

Series: Tips and Tricks

Author: Michael K. Campbell

Applies to SQL Server: 2000, 2005, and 2008.

Tags: Tips and Tricks, Indexing, T-SQL, and Storage Engine.

Code Download: 3 KB

Video Resources

Video References, Video Transcript, and Accompanying Source Code.

Related Videos

Nibbling Deletes, Ad-hoc Reporting, Using SQL Server Templates, and How to use SQLServerVideos.com

SQL Server Consulting


Viewer Comments

Submit Comments

spacer

Comments may be moderated.

The following pseudo-markup is permitted:
      bold : *strong*
      italic : _em_
      hyperlinks : [linktext|http://link.url.here]

 


spacer