One would assume that the rows are ordered in exactly the same way in both tables. if that is true, you could first select into a temp table like this...

I still think there is a bug in SSMS. Why would SSMS crap out everytime ? I had even tried moving the DB onto a server with 32 GB memory,...

Excellent suggestion Gail ! I was trying exactly that when I saw your post. I'll post back on how that goes.

By the way, I saw some blogs about this issue...

Thanks for the reply. Yes, it is a very complex query, and yes I did check for memory utilization. SQL is using dynamic and it acquires the max allowed memory...

SJT -

In the world of fund accounting, I can assure you that such divisions are very commonplace. Its a little difficult to explain in a forum without adding a...

Drew - many thanks for your reply. I have a follow up question posted. Would appreciate your insights on that.

Jason,

Excellent !! and many thanks for the reply. Please look at the modified code below. According to the documentation for the formulas used in calcs involving fixed point precision numbers(ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/fbc9ad2c-0d3b-4e98-8fdd-4d912328e40a.htm)...

It will, as long as there are no stats or indexes on that column. But marking a row as deleted will probably result in that "mark" column being indexed because...

Seems like a registry issue all right. Please look at this:

http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/a8cc09a9-7500-4fc3-90f4-fd5fff94509b

Sorry Dan - should have read all the way thru ...Does this help:

http://blogs.msdn.com/john_daskalakis/archive/2008/11/20/9128335.aspx

When you say you want to address I/O performance issues, I assume that you have already done the work on analyzing the I/O demands of your application. if not, it...

Thanks - that does make sense. It could not be the update stats blocking any DML. I will be doing a deep dive into the profiler trace - I am...

Gail - thanks for the post. I have to preface any of my comments with the fact that this is a 10 year old product and I only stepped into...

Thanks - Gail and Lowell. Yes, I know sysindexes is being deprecated, but as Lowell pointed out, it is very handy and having worked with SQL Server since 6.5, I...

The other thing I wanted to point out was, it's a high volume transactional environment(Financial data). It's not a warehouse where you load data at fixed time intervals. We can...