Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server 2005   (RSS)
Friday, June 01, 2007 9:51 AM

Store Statistics XML in database tables using SQL Traces for further analysis.

Since SQL Server 2005, query plan as well as statistics of query execution can be captured in XML format. Also, SQL Server 2005 has XQuery support to directly query XML document. By combining these two new features, users can analyze the query plans using
Posted by queryproc | 2 Comments
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 | 3 Comments
Thursday, February 01, 2007 7:18 PM

Hash Warning SQL Profiler Event

One of the less well-known warning events that is logged to SQL Profiler trace is the Hash Warning event . Hash Warning events are fired when a hash recursion or hash bailout has occurred during a hashing operation. Both of these situations are less than
Posted by queryproc | 2 Comments
Sunday, November 12, 2006 6:32 PM

Using ETW for SQL Server 2005

ETW stands for “Event Tracing for Windows” and it is used by many Windows applications to provide debug trace functionality. This “wide” availability is a key point of using ETW because it can help to track certain activities from end to end. For example,
Posted by queryproc | 3 Comments
Filed under: , ,
Friday, October 27, 2006 11:00 AM

Intro to Query Execution Bitmap Filters

One of the least understood Query Execution operators is the Bitmap . I'd like to give a fairly brief overview of how Bitmap filters are used, as well as some technical details about their limitations and functionality. Bitmap filters are often mistaken
Posted by queryproc | 3 Comments
Filed under:

Attachment(s): QE_Bitmap_Filters.jpg
Friday, October 20, 2006 1:57 PM

Statistics Profile Output Formatting

Statistics profile output is an important tool when it comes to troubleshooting query plan issues. When enabled, it returns a textual representation of the query plan with a lot of detail about cost and cardinality estimates as well as actual counts.
Posted by queryproc | 0 Comments
Attachment(s): statspro.pl
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
Tuesday, September 26, 2006 10:14 PM

Compilation Time Issues in OLTP Applications When Upgrading to SQL 2005

I've helped a lot of people upgrade their SQL 2000 applications to SQL 2005. While many of these upgrades go well, occasionally some applications have issues and the overall workload may perform more poorly after the upgrade. One area where I've seen
Posted by queryproc | 1 Comments
 
Page view tracker