Extra-Wide Covering Indexes

Extra-Wide Covering Indexes
2

- Details

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

Video Length: 07:55
Skill Level: 400 - Guru
Series: Tips and Tricks
Author/Presenter: Michael K. Campbell
Applies to SQL Server: 2000, 2005, and 2008

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

    Applicability

Analyst 0
DBA 60
Developer 40
Manager 0

 

- Downloads

SQL Server Consulting

+ Related Videos

+ Transcript

- Comments

Creating unique indexes on checksum columns is a bit "dangerous". It is possible that two different values can produce the same hashed value, and the unique index will give an error when it shouldn't

theworm - December 04, 2009.

what a clean explanation.. keep it up..

sathish dba - July 16, 2014.

Add A Comment

 

NOTE: Comments are moderated.

The following pseudo-markup is permitted:
      bold : text inside *stars* will be bold
      italic : text inside _underscores_ will be emphasized
      hyperlinks : [linktext|http://link.url.here]