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
Viewer Comments
SQL Server Videos are available free of charge.
But you must agree to the following terms before downloading:
Redistribution is prohibited.
Redistribution via any of the following means is prohibited.
• WebServer/HTTP, FTP,
• YouTube and similar sites,
• BitTorrent,
• CD/DVD, Portable Hard-drive, etc.
I already Agreed to these Terms
Non-registered users must agree to terms upon each new visit to the site.
Registration costs nothing, is painless, and is evil-free™. And SSV will never divulge your personal information to third parties. Ever.
Registered Users
Login Here.
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