An Instance of SQL Server 2000 Performance Tuning

(Sunil Madan) This article is about altering a table and adding NOT NULL columns into it. The table being altered contains MILLIONS of records. One straight forward approach could be: Step 1: Alter Table — Add Nullable Column. Step 2: Update Newly Added Column. Step 3: Alter Table — Modify New

Read More - Register for Free Membership