Beyond1_1

Beyond Statistics Histogram – Part 1

In this article I will start to examine estimations and execution plans for queries that compare values in columns with literal values which are beyond the statistics histogram for that column. The … [Read More...]

Beyond1_1

Beyond Statistics Histogram – Part 1

In this article I will start to examine estimations and execution plans for queries that compare values in columns with literal values which are beyond the statistics histogram for that column. The … [Read More...]

Beyond1_1

Beyond Statistics Histogram – Part 1

In this article I will start to examine estimations and execution plans for queries that compare values in columns with literal values which are beyond the statistics histogram for that column. The … [Read More...]

passaustria

PASS Austria Meeting on 30th October

Thanks to those who attended my talk on Thursday evening at Pass Austria Meeting. Click hereto download slide deck, SQL Server code repository templates and applications for genereting an install … [Read More...]

RECENT ARTICLES

Beyond1_1

Beyond Statistics Histogram – Part 1

In this article I will start to examine estimations and execution plans for queries that compare values in columns with literal values which are beyond the statistics histogram for that column. The … [Read More...]

9_6

A Funny Bug with New CE or Introduction to Out-of-Histogram Estimations

Since the release of SQL Server 2014 you can find several articles and blog posts about the changes in the new redesigned cardinality estimator. An excellent and detailed guide about the changes in … [Read More...]

8_8

New Cardinality Estimator Part 8 – Bug No. 2

In this article I will describe another query pattern where new CE in SQL Server 2014 brings significant regression. And, similar to the case in this post I would interpret the behavior of new … [Read More...]

Figure7_1

New Cardinality Estimator Part 7 – Single Table, Multiple Predicates and Trace Flags

This week I have got a question regarding my post New Cardinality Estimator Part 4 – Single Table and Multiple Predicates. The question was about possibilities to affect the estimation with multiple … [Read More...]

sqlsat275_web

Speaking at SQLSaturday 275 in Copenhagen

Last night I received an email that I have been chosen to speak at SQLSaturday #275 in Copenhagen on the 29th of March. I will present my session “SQL Server 2014 - New Cardinality Estimator” where … [Read More...]

More Articles

Follow

Get every new post delivered to your Inbox.