![What's New in SQL Server 2019: Faster Table Variables (And New Parameter Sniffing Issues) - Brent Ozar Unlimited® What's New in SQL Server 2019: Faster Table Variables (And New Parameter Sniffing Issues) - Brent Ozar Unlimited®](https://www.brentozar.com/wp-content/uploads/2018/05/sql_server_2017_plan.png)
What's New in SQL Server 2019: Faster Table Variables (And New Parameter Sniffing Issues) - Brent Ozar Unlimited®
![SQL — Count (*) using SUM CASE with multiple date ranges and WHERE conditions. | by Kyle Allbright | Medium SQL — Count (*) using SUM CASE with multiple date ranges and WHERE conditions. | by Kyle Allbright | Medium](https://miro.medium.com/max/806/1*D1pKFGV1n_KWntAYDMy8gQ.png)
SQL — Count (*) using SUM CASE with multiple date ranges and WHERE conditions. | by Kyle Allbright | Medium
![SQL — Count (*) using SUM CASE with multiple date ranges and WHERE conditions. | by Kyle Allbright | Medium SQL — Count (*) using SUM CASE with multiple date ranges and WHERE conditions. | by Kyle Allbright | Medium](https://miro.medium.com/max/1400/1*Gfv4WDWTvZGGuaGBEP6-4A.png)
SQL — Count (*) using SUM CASE with multiple date ranges and WHERE conditions. | by Kyle Allbright | Medium
![SQL — Count (*) using SUM CASE with multiple date ranges and WHERE conditions. | by Kyle Allbright | Medium SQL — Count (*) using SUM CASE with multiple date ranges and WHERE conditions. | by Kyle Allbright | Medium](https://miro.medium.com/max/1400/1*-jAr0KkBbxD9e3dsp4OKsA.png)