Tips, Tricks, and Advice from the SQL Server Query Processing Team

The query processing team - query optimization & execution - providing tips, tricks, advice and answers to freqeuently-asked questions in a continued effort to make your queries run faster and smoother in SQL Server.

Browse by Tags

Tagged Content List
  • Blog Post: 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 queries. However, in SQL Server, there...
  • Blog Post: 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. When working in SQL Server management Studio...
  • Blog Post: 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, and therefore deserves some extra exposure. Being...
Page 1 of 1 (3 items)