Welcome CisForCookie, the newest member
New user?    Register    Login
http://www.attackprevention.com


Date Submitted: 08/04/05
Hits: 71
Rating: 00000 based on 0 votes

Speeding UPDATEs Using the CASE Statement



Added 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.

Copyright 2008 AttackPrevention