Querying Databases in SQL Server 2005 - The Execution Plan

(Page 3 of 4 )

Again from the query menu, you can see the query Plan as in Fig.6. This plan is available for standard SQL statements and also for statements with the for XML clause. You might have observed that the tabs Messages and Results changed to Message, Execution Plan.

Fig. 6

The Query Designer

One way to call up the query designer was discussed earlier (from Query ->Design Query Editor...). The other option is calling from the query pane. The areas in the query pane (refer to Fig.6) where the query is typed-in and the results plane have context sensitive drop-down menus. By right clicking in an empty area in the query pane and choosing appropriate item, you can make all changes to the query as well as wake up the Query Designer, as shown in Fig.7. This was a feature in Enterprise Manager in SQL 2000, if you recall; in Visual Interdev (Visual Studio 6.0); VS IDE 2003; and other Microsoft data related products. For instructions on using this designer please look up the Book on Line (the BOL), or here.

 

Fig. 7

Next: XML Queries, a Comparison >>
 

More MS SQL Server Articles
More By Jayaram Krishnaswamy

Comments On: Querying Databases in SQL Server 2005

· A new major version is like entering a new territory. You start discovering new...   >>> Post your comment now!