I wouldn't advise restarting SQL Server as you could end up with a corrupted database after the restart. Let SQL Server finish it's rollback naturally. It's a pain but it...

Hah!!! Now I understand.... thanks! 😀

Well I believe I have solved the problem!

Originally I was creating my staging table with a clustsred index before I was populating it with the data coming from the CLR...

Hmmm.. Galimonster's last comment kind of makes sense but I'm still not entirely sure I understand what's going on.

Another thing which is really confusing is that I have a SQL...

Removing the filter from the index seems to have done the trick but I'm not satisfied completely as I don't understand the reason for this. Oh well... need to do...

I'm too slow.. lol

One ore more entries for the EZACDT column are not valid date formats.

You can add this to your query but it will skip records with invalid date format.

AND ISDATE(CONVERT(CHAR(8),...

Far more important than size of the Nvarchar fields is if you need the N at all!! 99.2% of the time I see Nvarchars at clients they state they...

Thanks Grant. Well it's back to the drawing board for me. Need to find other ways of doing the same thing in my code without retreiving so much data!

Okay great, just one more question that's been bugging me for a while.

My staging table has a lot of NVRCHAR(500) columns. Now I know many of my columns will never...

Silly question but regarding type conversions. If I have a column that's NVARCHAR(500) and I insert it into a new table that has a column of NVARCHAR(50), would that also...

Grant Fritchey (3/13/2013)

---

You're getting type conversions on a couple of the columns. I'd look to see if that might be causing issues. Also, a Nested Loops join for millions of...

anthony.green (3/13/2013)

---

Such a big difference between the estimated and the actual, which is why you should always attach the actual plan as that is what SQL actually does not just...

Please see latest attached file.

Also why all the indexes on varbinary(8000) columns? The max length for an index key is 900 bytes, so inserts of anything over 900 bytes will cause the insert...