Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server 2005 » Showplan   (RSS)
Monday, April 09, 2007 11:52 AM

How to Check Whether the Final Query Plan is Optimized for Star Join Queries?

The star join optimization technique is an index based optimization designed for data warehousing scenarios to make optimal use of non-clustered indexes on the huge fact tables. The general idea is to use the non-clustered indexes on the fact table to
Posted by queryproc | 4 Comments
Tuesday, October 17, 2006 12:57 PM

Showplan Trace Events

Besides SSMS, another great tool available to database developers and DBAs to view query plans and troubleshoot query compilation or execution issues is the SQL Server Profiler. In the Profiler, all the showplan events are listed under the Performance
Posted by queryproc | 1 Comments
Attachment(s): statistics1.xml
Friday, October 06, 2006 2:03 PM

Viewing and Interpreting XML Showplans

As mentioned in our previous blog posting, SQL Server 2005 supports Showplan generation in XML format. XML-based Showplans provide greater flexibility in viewing query plans and saving them to files as compared to legacy Showplans. In addition to the
Posted by queryproc | 1 Comments
Attachment(s): showplan.xml
Friday, September 29, 2006 3:16 PM

Introduction to Showplan

Showplan is a feature in SQL Server to display and read query plans. While some of you may already be very familiar with Showplan, it is one of the most important diagnostic tools that we use in the query processing team to locate and identify problems,
Posted by queryproc | 0 Comments
Attachment(s): showplan_blog.bmp
 
Page view tracker