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…

Be Sociable, Share!
    Related posts:
    1. How Do You Defragment Your SQL Server Indexes
    2. Don’t Make Dumb Mistakes by Duplicating Indexes
    3. Becoming a Part of the SQL Server Twitter Community
    4. Free T-SQL Database Maintenance Scripts
    5. Don’t Forget to Maintain Your Indexes

    Copyright 2009-2011 Brad M McGehee