If you use re-index, on the run set dboption to bulk_logged and at end set it to original setting.

although this is not the correct sequence to do this, if the db is not corrupted you 'are fine. There is 'No data loss'.

if I unserstood problem correctly this is a another solution..

select distinct * int #temp

from sourceTable

drop table sourcetable

insert sourceTable

select * from #temp

drop table #temp

go

Any smart explanation ?

Whatever you all say the correct and most appropriate answer is b which is to change to update lock.

This will keep data intergrity and solves the deadlock problem. If...

HI,

Yes using cursors will be a weapon of mass destruction if you use everywhere. It is technique you should use as a last resort. They are enefficient and create more...

Thanks for all contributions. I believe in this situation sql use hash function for matching operation. So Does the efficiency of the search depends on the order of the input...

Dear,

If nothing works take long breath and realx. then do your reatoration on the old server I mean with all differential backups. Then you have the full database. Just upgrade...