February 2017 - Posts

• Fixing the Query Optimizer Cost Model

  The model for the cost of operations used by the SQL Server query optimizer to produce an execution plan is rather simple. It has been largely unchanged since SQL Server version 7, RTM in 1998. Back then, SQL Server had not yet achieved tier 1 status Read More... Posted Monday, February 20, 2017 4:26 PM by jchang | 9 Comments

• Parallel Execution on SQL Server 2016

  There are a number of interesting questions in parallel execution performance that can be investigated using the TPC-H kit, which has a data generator. There are also supplemental files that accompany published results. Important questions in parallel Read More... Posted Wednesday, February 1, 2017 11:33 AM by jchang | 22 Comments