Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DMWCincy
Starting Member
11 Posts |
 Posted - 2006-07-14 : 22:20:55
|
| I have two tables that I have to update all the rows. I'm running SQL Server 2000 and have one table with 10 million rows and the second one have around 25 million rows. What I need to do is encrypt 4 columns in each table(varchar(20) --> varchar(100)). This will greatly increase the size of each of the columns plus we will have to pull each row out, encrypt the data as needed and update the table. I have the encryption app optimized as possible but is there any suggestions on what I should do for SQL Server so I don't kill it? So far our db is around 25 GB in size and after running the encryption on the test db we are close to 50GB for both the data and log files. Is this to be expected or is there anything I should before and during the updates. Thanks ahead of time. |
|
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2006-07-18 : 15:42:47
|
| 1. Check for proper Indexes there are not.2. Log space for Transaction log3. Update data chunk by chunk4. Any chance disable FKeys and TriggersWith RegardsBSR |
 |
|
|
|
|
|
Changing data in two large tables