Browse by Tags

• Internals
• Joins
• Partitioning
• Performance
• Query Plans
• Seeks
• Undocumented

• Why Doesn’t Partition Elimination Work?

  Given a partitioned table and a simple SELECT query that compares the partitioning column to a single literal value, why does SQL Server read all the partitions when it seems obvious that only one partition needs to be examined? Sample Data The following Read More... Posted Wednesday, September 12, 2012 10:52 AM by Paul White | 20 Comments Filed under: Query Plans, Performance, Conversions, Partitioning

• Dynamic Seeks and Hidden Implicit Conversions

  This article has permanently moved to https://sqlkiwi.blogspot.com/2012/01/dynamic-seeks-and-hidden-implicit-conversions.html Read More... Posted Wednesday, January 18, 2012 2:37 AM by Paul White | 18 Comments Filed under: Seeks, Performance, Conversions

• Join Performance, Implicit Conversions, and Residuals

  This article has permanently moved to https://sqlkiwi.blogspot.com/2011/07/join-performance-implicit-conversions-and-residuals.html Read More... Posted Tuesday, July 19, 2011 1:17 AM by Paul White | 17 Comments Filed under: Internals, Query Plans, Undocumented, Performance, Joins, Conversions