SELECT *
FROM Posts
WHERE Tags IN ('Statistics')

Feb
9
2017

Statistics and Data types, What can go wrong?

One of the most interesting things in SQL Server from my point of view are Statistics and how the optimizer interprets them to produce optimal query plans. But today I want to write about something…

Continue Reading »

Sep
30
2016

Multi-column statistics are back in SQL Server 2016

Don’t get me wrong, they’ve always been there, but somehow someone forgot about them and weren’t used. Since last…

Continue Reading »

Jun
22
2016

Update Statistics Misconception

On the 15th of June I made my first presentation at my local user group, and I have to say that was a nice experience. The presentation is about SQL Server statistics and at certain…

Continue Reading »

Mar
3
2016

Fast with values slow with variables

The other day I saw a thread on linkedin groups that was titled ‘Using Parameters in a Query is Killing Performance’, where the author…

Continue Reading »