10 June 2009

Why use SQL 2008 client tools

Here’s a quick example of a time saving query analysis feature with SSMS 2008.

We want to examine the performance of a query. When we run the query, and ask for the actual execution plan, SSMS 2008 will also display missing indexes that the server thinks would speed the query (this example is estimated to have a 64% impact on the query):

Just right click on the “missing” index (in green) and choose “Missing Index Details…”

No comments: