Monthly Archives: December 2018

SQL 2019:- Truncation Error message and where it fails

I was wondering if I should even bother checking this feature out since it was pretty obvious what it does and how useful it is. I can’t even begin to explain how many times I have had to troubleshoot truncations errors when working with customer data. The basic thing about this feature is that now… Read More »

SQL 2019:- Table Variable deferred compilation – PART 2

In the last post we ended with two questions remaining unanswered. Shouldn’t a more accurate row count have resulted in the correct amount of memory being granted and more importantly why didn’t intelligent Query processing detect and correct the issue in subsequent runs? We were exploring the improved performance of Table Variable deferred complication to… Read More »