L1

Beyond Statistics Histogram Part 4 – Significant Performance Regression in SQL Server 2014

In the previous articles we’ve covered differences in estimations between the old and new CE related to queries that use predicates with literals which values are beyond the statistics histogram. We … [Read More...]

L1

Beyond Statistics Histogram Part 4 – Significant Performance Regression in SQL Server 2014

In the previous articles we’ve covered differences in estimations between the old and new CE related to queries that use predicates with literals which values are beyond the statistics histogram. We … [Read More...]

L1

Beyond Statistics Histogram Part 4 – Significant Performance Regression in SQL Server 2014

In the previous articles we’ve covered differences in estimations between the old and new CE related to queries that use predicates with literals which values are beyond the statistics histogram. We … [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

L1

Beyond Statistics Histogram Part 4 – Significant Performance Regression in SQL Server 2014

In the previous articles we’ve covered differences in estimations between the old and new CE related to queries that use predicates with literals which values are beyond the statistics histogram. We saw some issues with key ascending columns in SQL Server 2012 which can be solved with the trace flags 2389, 2390 and 4139. And […]

RECENT ARTICLES

sqlsatlisboa

Speaking in Lisbon at SQLSaturday Portugal

I' am really excited to back as a speaker to my favorite SQL Saturday event - Sql Saturday Portugal in Lisbon. The SqlSat 369 will be my fourth event in one of the most beautiful cities in the world. I am happy … [Read More...]

1201

Beyond Statistics Histogram – Part 3 (TF 2389 feat. TF 4139)

In the previous article we’ve shown how can we use TF 2390 to handle queries with literals beyond statistics histogram in SQL Server 2012. We saw that SQL Server creates some statistics on the fly for all … [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 pre-con … [Read More...]

More Articles

Follow

Get every new post delivered to your Inbox.