I am speaking at Microsoft Sinergija 18 Conference Belgrade

I’m very glad that I will present again at Microsoft Sinergija 18 conference in Belgrade on October 25th 2018. Microsoft Sinergija 18 will be held from October 24 through 26 at the Crowne Plaza hotel … [Read More...]

I am speaking at Microsoft Sinergija 18 Conference Belgrade

I’m very glad that I will present again at Microsoft Sinergija 18 conference in Belgrade on October 25th 2018. Microsoft Sinergija 18 will be held from October 24 through 26 at the Crowne Plaza hotel … [Read More...]

Altering an Indexed Text Column

In this post, I am going to demonstrate how increasing the size of a text column with an index on it can lead to serious troubles without warning. I tested it two instances of SQL Server: SQL Server … [Read More...]

I am speaking at Microsoft Sinergija 18 Conference Belgrade

I’m very glad that I will present again at Microsoft Sinergija 18 conference in Belgrade on October 25th 2018. Microsoft Sinergija 18 will be held from October 24 through 26 at the Crowne Plaza hotel … [Read More...]

SQL Server 2017 Developer’s Guide

Together with Dejan Sarka (blog | twitter) and William Durkin (blog | twitter) I have finished writing the SQL Server 2017 Developer’s Guide book. The book is available at the Packt Publishing portal … [Read More...]

Last Post

Table Variable Deferred Compilation in SQL Server 2019 CTP2- Undocumented Options

At the time of writing and publishing the series of articles about the Table Variable Deferred Compilation feature in SQL Server 2019 CTP2, I did not know about undocumented options and hints related to it, but in the meantime, thanks to Dmitry Pilugin (blog | twitter), I learned how you can play with table variables […]

RECENT ARTICLES

The Good, the Bad and the Ugly of Table Variable Deferred Compilation – Part 3

In the final article in this series, you will see how new behavior of table variables in SQL Server 2019 CTP2 called Table Variable Deferred Compilation can break existing performance workarounds. As mentioned … [Read More...]

The Good, the Bad and the Ugly of Table Variable Deferred Compilation – Part 2

In two previous articles, you saw how new behavior of table variables in SQL Server 2019 can improve execution plans. This article demonstrates another aspect of this behavior, which is by design neither good, … [Read More...]

The Good, the Bad and the Ugly of Table Variable Deferred Compilation – Part 1

As mentioned in the previous article, SQL Server 2019 cardinality estimations for a table variable are based on actual table variable row counts. Therefore, in SQL Server 2019, we should expect better … [Read More...]

Introduction to Table Variable Deferred Compilation

Prior to SQL Server 2019, cardinality of a table variable was hardcoded to 1, regardless of number of rows in it. The only way to see a different (and accurate) value there is to run a statement with the OPTION … [Read More...]

Altering an Indexed Text Column

In this post, I am going to demonstrate how increasing the size of a text column with an index on it can lead to serious troubles without warning. I tested it two instances of SQL Server: SQL Server 2016 and … [Read More...]

Speaking at CI SQLPort Meeting in Lisbon

As always, I had a great time in Lisbon. I enjoyed this beatiful city and also visited Cascais and spent some time in the Atlantic ocean. But, Lisbon and Portugal are not only natural beauties, but also warm, … [Read More...]