The Curious Engineer

All blogs / Databases

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

learn.microsoft.com/en-us/archive/blogs/sqlqueryprocessing

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.

DatabasesPerformance / optimizationMicrosoft blogsMSDN archive

’10’15’20’25
Posts
27 from 20 Sep 2006 to 11 Mar 2010
Posting
archived, read-only
Kind
project news
Feed
https://learn.microsoft.com/en-us/archive/blogs/sqlqueryprocessing/feed.xml

2010 2

  1. Mystery of memory fraction in Showplan XML
  2. Understanding SQL server memory grant

2009 1

  1. Understanding SQL Server Fast_Forward Server Cursors

2008 1

  1. Distinct Aggregation Considered Harmful

2007 7

  1. Store Statistics XML in database tables using SQL Traces for further analysis.
  2. Index Build strategy in SQL Server - Part 4-2: Offline Serial/Parallel Partitioning (Non-aligned partitioned index build)
  3. Index Build strategy in SQL Server - Part 4-1: Offline Serial/Parallel Partitioning (Non-aligned partitioned index build)
  4. How to Check Whether the Final Query Plan is Optimized for Star Join Queries?
  5. Hash Warning SQL Profiler Event
  6. Index Build strategy in SQL Server - Part 3: Offline Serial/Parallel Partitioning (Aligned partitioned parallel index build)
  7. Index Build strategy in SQL Server - Part 3: Offline Serial/Parallel Partitioning

2006 16

  1. Index Build strategy in SQL Server - Part 2: Offline, Parallel, No Partitioning (Non stats plan (no histogram))
  2. Index Build strategy in SQL Server - Part 2: Offline, Parallel, No Partitioning
  3. Query Execution Timeouts in SQL Server (Part 2 of 2)
  4. Index Build strategy in SQL Server - Part 1: offline, serial, no partitioning
  5. Query Execution Timeouts in SQL Server (Part 1 of 2)
  6. Using ETW for SQL Server 2005
  7. Index Build strategy in SQL Server - Introduction (II)
  8. Index Build strategy in SQL Server - Introduction (I)
  9. Intro to Query Execution Bitmap Filters
  10. Statistics Profile Output Formatting
  11. Showplan Trace Events
  12. Viewing and Interpreting XML Showplans
  13. Introduction to Showplan
  14. Compilation Time Issues in OLTP Applications When Upgrading to SQL 2005
  15. Query Processing -- introduction to the blog!
  16. Greetings!