Flow of Data During Query Processing
If you want to make the upcoming example a hands-on experience, start SQL Server Management Studio (SSMS). Run the query shown in Example 2-1 against the Northwind database, after clicking the Include Actual Execution Plan icon, as shown in Figure 2-1.
Figure 2-1. Include Actual Execution Plan option
Note
The Northwind database is not shipped with SQL Server 2005. You can download the SQL Server 2000 version (which works on SQL Server 2005 as well) from http://www.microsoft.com/technet/prodtechnol/sql/2000/downloads/default.mspx ...
Get Inside Microsoft® SQL Server™ 2005: T-SQL Querying now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
