Could someone suggest a resource that would help me understand what query
plans are telling me? For example, I don't know if a Bookmark Lookup is a
good thing, or the difference between an Index Scan vs. an Index Seek etc.
Ultimately I would like to be able to look at a query plan and adjust my
queries accordingly, but I first need to understand what it's telling me.
SQL Server Developer >> Query Plans
You could try to free 30 day trial of SQL Optimizer for Visual Studio. It
automatically find, rewrites all your SQL Statements to find the best
solution for your application. It also has a lot of help on each of the
query plan steps and you can compare all the different rewrites to
understand the differences. You can find the product at