SQLBits 2020

When Anti-Patterns Become Best Practices

SQL Server has long had a series of development anti-practices like using scalar functions and table valued functions that are vastly improved in modern versions of the database engine. Learn what's fixed.

SQL Server has always had a number of anti-patterns that didn't make any sense to application developers. Why shouldn't I be able to use scalar function? Or why can't I put a large number of rows in a table variable? SQL Server 2019 and Azure SQL Database have eliminated a number of these anti-patterns. In this session you will learn about how these changes can improve your application performance, and change your application development patterns. You will also learn about potential gaps where your application may not benefit from the changes to the database engine.