Thats cool. Add to my question above. If a single row is 3 page big. Does it mean SQL needs to read 3 page before it can update a single field ?
> 25 million new rows per day ??? whats the nature of the application ? My new job will require this ....
Great thank you very much...cause this is the first time i deal with > 1 million rows... Downloaded my client's customers base to my Notebook :)
So the update process is like this ? Read the page, update a single field and write the whole page ?
It involves a lot of rows like 10% out of 6million rows. I have tested this..and now in the process of narrowing the columns. I just want to confirm...
OOps sorry this is sql 2005 ..but i think this is very general and applies to all.
Question: Does updating a table with 200 fields is slower than updating 10 fields table ? (all fields is same size). And the update here is just...
Separate names with a comma.
