|
|
|
Date Submitted:
08/04/05
Hits: 71 Rating: ![]() ![]() ![]() ![]() based on 0 votes
Speeding UPDATEs Using the CASE StatementAdded by Papergrl
Description:
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, and performance boosted.
Read the Complete Paper You don't have permission to post replies. Please login or register. |
