Speeding UPDATEs Using the CASE Statement

(Neil Boyle) One of the keys to SQL Server database performance if keeping your transactions as short as possible. In this article we will look at a couple of tricks using the CASE statement to perform multiple updates on a table in a single operation. By doing this, some transactions can be shorted

Read More - Register for Free Membership