Here's a collection of such nuggets for developing SQL Server applications. 1) Replace COUNT(*) With EXISTS When Checking for Existence Developers often use the value from the COUNT(*) function when ...

Like most databases created in the last few decades, SQL Server allows developers to extend the database by creating functions. But prior to the upcoming 2019 release, SQL Server’s support for ...