Paul White explains a few different ways to retrieve distinct values from a table, including some big "it just runs faster" wins in SQL Server 2019.
Category: SQL Server 2019
Adrian Hills shares how SQL Server 2019 introduces enhancements for using scalar UDFs to improve the performance of your system.
Itzik Ben-Gan discusses the ins and outs of numbering and retrieving rows in a nondeterministic (but explicitly not random) order.
Aaron Bertrand shares his thoughts about the upcoming SQL Server 2019 release and, specifically, edition-specific features.
See the builds, release dates, and database versions of SQL Server 2019.
Erin Stellato uses simple examples to demonstrate performance benefits you might expect from enabling memory-optimized tempdb metadata in SQL Server 2019.
Aaron Bertrand provides his deck and demos for a GroupBy presentation on SQL Server 2019, and makes up for some serious demo disasters.
Today Microsoft announced the first public preview of SQL Server 2019. I've got some exclusive details over at MSSQLTips.com.
