When QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_140 does not follow CL 140 rules

In this short post, I will demonstrate (for me) an unexpected behavior of one query hint. In August 2018, Microsoft introduced a new query hint QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_n to let you force … [Read More...]

When QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_140 does not follow CL 140 rules

In this short post, I will demonstrate (for me) an unexpected behavior of one query hint. In August 2018, Microsoft introduced a new query hint QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_n to let you force … [Read More...]

SQL Server 2019 CE, Local Variables and Nullable Columns

In this article, I will demonstrate a small change in the Cardinality Estimator component under the latest compatibility level - 150 (SQL Server 2019). Let's first create and populate a sample … [Read More...]

Speaking at IT-Tage 2019 Conference in Frankfurt

I am honored to have been selected to speak at one of the largest database conferences in the German-speaking area "IT-Tage 2019" in Frankfurt. The 3-day conference will be held from 10th to 12th … [Read More...]

Quo vadis iliti j*** te fičer koji sve radi umesto mene a ja moram ništa

Ovaj post ima previše psovki da bi bio napisan na engleskom jeziku, al računam da nije malo i to što će dopreti do onih koji se služe srpskohrvatskim jezikom. Postalo je gotovo nesnosno kako … [Read More...]

Last Post

Speaking at IT-Tage 2019 Conference in Frankfurt

I am honored to have been selected to speak at one of the largest database conferences in the German-speaking area “IT-Tage 2019” in Frankfurt. The 3-day conference will be held from 10th to 12th December 2019, with a pre-con day on 9th December. I’ll be presenting features within Intelligent Query Processing in SQL Server 2019. […]

RECENT ARTICLES

Slovak SQL Server & BI Meeting on 19th November

Next week I'll be back in Bratislava. I have the honor to present at the Slovak SQL Server & BI User Group's meeting. This time, I am gonna talk about developer's features in SQL Server 2019. We'll go … [Read More...]

Miracle of OPTIMIZE_FOR_SEQUENTIAL_KEY

SQL Server 2019 provides another option to deal with the last-page insert contention - OPTIMIZE_FOR_SEQUENTIAL_KEY. It improves throughput for high-concurrency inserts into an ascending clustered index. Unlike … [Read More...]

Dude, Where’s My Forced Plan?! – Part 2

In my previous post about Query Store, you saw that the persistence of forced plans does not imply that they are used. This post brings another example where forced plans are still in the system, with no … [Read More...]

SQL Server 2019 CE, Local Variables and Nullable Columns

In this article, I will demonstrate a small change in the Cardinality Estimator component under the latest compatibility level - 150 (SQL Server 2019). Let's first create and populate a sample table: DROP … [Read More...]

Dude, Where’s My Forced Plan?! – Part 1

Query Store is a great performance troubleshooting tool. I like it; in the past three years, it saved me a lot of time and money. It allows you to quickly identify exec plan regressions. By forcing an old plan, … [Read More...]