300x250_SQL_Server_Konferenz_EN

Speaking at Deutsche SQL Server Konferenz 2015 in Darmstadt

I am honored  to have been selected to speak at the largest SQL Server conference in the German speaking area "SQL Konferenz 2015". The 2-day conference will be held from 4 to 5 February 2015, with a … [Read More...]

1001

Beyond Statistics Histogram – Part 2 (TF 2390)

In the previous article of this series we introduced the problem with queries using literals which are beyond statistics histogram, but exist in the table. We saw that this can be a serious problem in … [Read More...]

300x250_SQL_Server_Konferenz_EN

Speaking at Deutsche SQL Server Konferenz 2015 in Darmstadt

I am honored  to have been selected to speak at the largest SQL Server conference in the German speaking area "SQL Konferenz 2015". The 2-day conference will be held from 4 to 5 February 2015, with a … [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...]

Last Post

300x250_SQL_Server_Konferenz_EN

Speaking at Deutsche SQL Server Konferenz 2015 in Darmstadt

I am honored  to have been selected to speak at the largest SQL Server conference in the German speaking area “SQL Konferenz 2015“. The 2-day conference will be held from 4 to 5 February 2015, with a pre-con day on 3rd February. I’ll be presenting a session about Key Ascending problems with large tables in […]

RECENT ARTICLES

1001

Beyond Statistics Histogram – Part 2 (TF 2390)

In the previous article of this series we introduced the problem with queries using literals which are beyond statistics histogram, but exist in the table. We saw that this can be a serious problem in large … [Read More...]

CE

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 problem is … [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 the new CE … [Read More...]

More Articles

Follow

Get every new post delivered to your Inbox.