Browse by Tags

• Conversions
• Performance
• Prefetch
• Undocumented

• SQL Server Internals: Nested Loops Prefetching

  Nested loops join query plans can be a lot more interesting (and complicated!) than is commonly realized. One query plan area I get asked about a lot is prefetching. It is not documented in full detail anywhere, so this seems like a good topic to address Read More... Posted Saturday, August 31, 2013 3:24 PM by Paul White | 7 Comments Filed under: Internals, Query Plans, Undocumented, Joins, Prefetch

• Join Performance, Implicit Conversions, and Residuals

  You probably already know that it’s important to be aware of data types when writing queries, and that implicit conversions between types can lead to poor query performance.  Some people have gone so far as to write scripts to search the plan cache Read More... Posted Tuesday, July 19, 2011 1:17 AM by Paul White | 16 Comments Filed under: Internals, Query Plans, Undocumented, Performance, Joins, Conversions