Monthly Archives: November 2018

SQL 2019:- Table Variable deferred compilation

By | November 30, 2018

One of the features being released in SQL 2019 that has got some attention is table variable deferred compilation. As its name suggests it applies to Table Variables and not temp tables, CTEs, or table datatypes. More importantly why does it need to do deferred complication for Table variables? One of the drawbacks of Table… Read More »

Using Time Series DAX functions in PowerBI

By | November 29, 2018

Recently at a training I was asked how to implement DAX Time Series functions like parallel period and YTD in PowerBI. I always assumed that I had something written up about it but on closer inspection found that I have missed writing about such an important piece of functionality. So here is a step by… Read More »

Tuning SQL Server – Simulating Performance issues

By | November 16, 2018

  Check out the second video on our series on Tuning SQL Server. After explaining the data model in the first video, where we cover the process by which we caused the performance issues. In this second video of the series I show how we can call procedures using OStress.exe to simulate hundreds of users… Read More »