One of the most interesting things in SQL Server are Statistics. Today I want to write about the creation and update. One of the most interesting things in SQL Server from my point…
Tag: Statistics
Multi-column statistics are back in SQL Server 2016
The new cardinality estimator in SQL Server 2014 brought new and improved query performance but as always there are caveats. Let’s check a specific case to see the different behaviors for the…
Update Statistics Misconception
Having statistics up to date is important to get good query plans, but sometimes how to get it might be misunderstood On the 15th of June I made my first presentation at my…
Fast with values slow with variables
There is a big debate why the same query can run fast with hard coded values and slow when using variables, come see there is a reasonable explanation for all this mess. The…