A blog by Jose Barreto, a member of the File Server team at Microsoft.
All messages posted to this blog are provided "AS IS" with no warranties, and confer no rights.
Information on unreleased products are subject to change without notice.
Dates related to unreleased products are estimates and are subject to change without notice.
The content of this site are personal opinions and might not represent the Microsoft Corporation view.
The information contained in this blog represents my view on the issues discussed as of the date of publication.
You should not consider older, out-of-date posts to reflect my current thoughts and opinions.
© Copyright 2004-2012 by Jose Barreto. All rights reserved.
Follow @josebarreto on Twitter for updates on new blog posts.
I'm attending a SQL training and looking at indexing closely. One thing that becomes important is understanding how SQL executes queries. Understanding the graphical execution plans becomes extremely important. While looking for a good reference, I found it in books online:
Graphical Execution Plan Icons (SQL Server Management Studio)http://msdn.microsoft.com/en-us/library/ms175913.aspx
As usual, Books Online is a great reference but it does help you understand them and there are no details and screenshots. I did find a nice article that describes some of the most important ones in good detail, with sample queries and nice screenshots:
Check it out at: Graphical Execution Plans for Simple SQL Querieshttp://www.simple-talk.com/sql/performance/graphical-execution-plans-for-simple-sql-queries/
For deeper info on this, you can also take a look at: Query evaluation techniques for large databaseshttp://portal.acm.org/citation.cfm?id=152611
It will take you a long time to learn all the details, but there is some great info out there. It will definitely help with your indexing strategies.