SQL Aloha

Brad’s Sure Guide to Indexes

There are many different types of index that exist in SQL Server. In this guide, I look at what a table and index are, before exploring how SQL Server 2005 and 2008 indexes work, including those that are filtered, special and compressed. Read more…

1. Don’t Make Dumb Mistakes by Duplicating Indexes
2. Don’t Forget to Maintain Your Indexes
3. Reasons Why You May Not Want to Use a Heap
4. An Introduction to Data Compression in SQL Server 2008
5. How to Become an Exceptional DBA, 2nd Edition, Now Available Free