SQL Server 2019

Brent Ozar reading

Froid: How SQL Server 2019 Might Fix the Scalar Functions Problem

Scalar functions and multi-statement table-valued functions are notorious performance killers. They hide in execution plans, their cost is under-estimated, the row estimates are way off, they cause queries to go single-threaded, I could go on and on. The Connect item about their performance has historically been one of the top-voted complaints out there. At Summit…
Read More
Brent Ozar reading

What Would You Put in SQL Server 2019?

If you were leading Microsoft’s development programs, what would you add or change in SQL Server 2019? Forget licensing or pricing changes – that’s dictated by the marketing teams, and those decisions are made really close to the release date. Instead, let’s think bigger: what are the really big improvements you’d make that would really…
Read More
Menu
{"cart_token":"","hash":"","cart_data":""}