SQLChicken.com

SQL Server DBA Tips & Tricks

By

SQL University: Indexes

Good day students! Unfortunately your professor who was supposed to cover indexes (that’s a pun, you’ll learn why in the following lessons) fell ill so we had to call in a guest professor. I’m honored to introduce to you professor Gail Shaw (Blog | Interview)! Gail has written a series of articles on indexes at SQLServerCentral.com. In order to read these articles you will have to create an account, don’t worry it’s free and HIGHLY recommended as SQL Server Central has some of the best SQL material around!

So without further ado, here are your indexing lessons for the week:

Introduction to Indexes

The Clustered Index

The Non-Clustered Index

Supplemental indexing material:

Additional Indexing articles by Gail Shaw (from her blog) Recommended Reading

Index Primer-Just what statistics are Kept? (author: Josef Richberg)

A big “thank you” again to Gail for giving us permission to add her work to the SQL University curriculum! Don’t forget to head over to the basketball court and let coach Tom Larock help you put your newfound skills to the test.

Click here to leave course feedback

Share

One Response to SQL University: Indexes

  1. Pingback: Tweets that mention SQL University: Indexes | The SQL UPDATE Statement -- Topsy.com

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">