yes Adm_History2 has 50k records

so what would be the best way to update millions of records in batches if my query will loop for ever, can you pelase point me...

I still doubt if my query is correct for the logic i have given because i tried this query on a table of 50k records keeping them in transaction but...

from the above query, does the update perform better if I create non CI indexes on revno and fixpaid.

How about creating this set of transaction for each table and adding all these sets into one job step by that way i can do this for multiple databases in...

thanks for the info.

I have update a table (50 million) witout using batch and it ran for 17hrs and i killed so its rolling back. how do i knoe how...

can i do all my updates given above in the same transaction ? I was doubting as it invovles multiple tables.

is this update statement correct?

WHILE (1 = 1)

BEGIN

BEGIN TRANSACTION

update TOP (10000) dbo.Adm_History2

set fixpaid = case when...

how about doing this in batches as it involves 50 millions of records and i dont have that much log space.

how can i optimize this query, it taking very long...

I have something weired, i am kind of testing RAID 10 and RAID 5 by some insert queries, I am doing an insert into a permanent table on both RAID...

nope, it does not have any trigger.

any idea why this would use temp table?

I agree with you but i am cocnered about the perofrmance if i drop to 6 as the other 2 cpu's will be idle unless some one queries using query...

So I think i can configure MAX DOP to 7 as i have 8 and if required when necessary people can use query hint so that they can use max...

if i want to enable them at query level, does any user has that previalge or only admin. IF all users can uses that but still what wud be the...

is there a way i can give ddl_admin but would like to restrict them from dropping any tables?