Naj ti poljub nariše ustnice – SQL Sat Slovenia T-16

In 16 days starts SQL Sat Slovenia conference and I am recalling today an old great song from the Slovenian band “Lačni Franz” in a new, acoustic arrangement. Naj ti poljub nariše ustnice as introduction to another pre-Christimas SQL Saturday Slovenia. Enjoy!         Advertisements

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 tables in SQL Server 2012. We saw also that SQL Server 2014 handles it better. In this article we’ll […]

Speaking at SQLSaturday Slovenia

I’m proud to announce that I will present at SQLSaturday Slovenia on December 13th, 2014. This time I will talk about Hekaton topic. The session name is “SQL Server 2014 In-Memory OLTP Challenges for Developers”. This will be second SQLSaturday conference in Slovenia. I was honored to present at the first one last year, a […]

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 also known as key ascending column statistics problem. As in previous posts we remain here conservative regarding sample tables. We’ll create […]

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 you can find in the white paper Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator. Almost […]

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 cardinality estimator in this case as a bug, too. Let’s recreate our usual sample table and populate it this time with […]

SQL Saturday Vienna On 28th February

Now it is official: SQL Saturday will return to Austria on Feb 28th 2015! And this time it us indeed a Saturday. Stay tuned for another ‪#‎sqlsatVienna‬!    

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 script and database initialization.