Scalar UDFs in SQL Server have very bad reputation. You can find a lot of articles why they are bad and why you should avoid them. When you google them, here are article captions...
Speaking at the Intelligent Cloud Conference 2019 in...
I am delighted to have been selected to speak at the Intelligent Cloud Conference 2019 in Copenhagen on 9th April. I am gonna talk about Intelligent Query Processing in SQL Server 2019. See...
SQL Server 2019 Query Store Defaults
When you look at articles, posts and documents about new features and enhancements in SQL Server 2019 CTP2, you will find nothing about Query Store. However, there are some graphical...
Workshop: Performance and Query Tuning with SQL Server...
As part of the SQL Saturday Linz conference, I will have a performance tuning workshop on 17th January in Tabakfabrik in Linz. The full workshop name is Performance and Query Tuning with...
Speaking at the BLBit user group and SQL Saturday...
Last week, we had a great time in Banja Luka. On 1st November, together with my friend and fellow Data Platform MVP and book author Dejan Sarka I talked about common database design...
I am speaking at Microsoft Sinergija 18 Conference...
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...
Table Variable Deferred Compilation in SQL Server 2019...
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...
The Good, the Bad and the Ugly of Table Variable...
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...
The Good, the Bad and the Ugly of Table Variable...
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...
The Good, the Bad and the Ugly of Table Variable...
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...