How to generate query (estimated) execution plan using SSMS

by Jagadish Pulakhandam on 9/23/2011 9:59:18 AM
Rated 0 from 0 votes
Brief: Demonstrates on generating Query Execution Plan using SSMS
Posted to: Microsoft SQL Server - Quick Learn ("How to"s for Developers)
Add to DiggAdd to del.icio.usAdd to FURLAdd to RedditAdd to YahooAdd to BlinklistAdd to GoogleAdd to ma.gnoliaAdd to ShadowsAdd to Technorati

Attached video demonstrates on the following:
  • Take a complicated query (from a view in Northwind database)
  • Execute it to show the results
  • Execute again to show the query execution plan (and its details)
NOTE: The video does not show on tuning a query to perform better/faster.  It just shown on showing up the execution plan.

Join the .NET Code Central Community and join the discussion!
Signing-up is FREE and quick. Do it now, we want to hear your opinion
0

Rated 0 from 0 votes ( login  to rate)
DotnetKicks DotnetKicksDe DotNetShoutout


Video/Screen Recording (may not have audio narration/annotations)
You need to Login or Join for FREE to download the following