I have no idea what the problem was. However, we had the opportunity to restart the server as a part of todays release process. The restart seems to...

hah! Try it with Workgroup edition - you can't even connect to a different SQL Server! :w00t:

Surely drop table is quicker?

Whoa! That is wierd. I have just come on here to post THE SAME thing!

I don't know when it happened - but by Saturday Lunchtime GMT I could only...

Thanks - I think I mentioned that.

Hi

I quite like the exposition of the rownumber and over stuff.  Interesting.

What I would ask is whether the performance issues relating to the and(x is null or x = y)...

Now I am sold on that product!  Will PO today

Theres a product key

Cheers for the ideas... must admit I was hoping someone would point me at some extensions for reporting services that function... !    Ah well,...

Second now!

https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5395

google katmai ctp.  Its about the 5th result - 1st from ms.

Check out the data distributions (sp_spaceused) on each table.  You may find <horror> that a join hint might sort things out a bit...

Your deduction is correct.  By making use of the udf you force a cursor like solution (pop open a trace and you can see it).  If you stick with standard...

You could try smaller batches.  make sure they are not in the same transaction tho... and try sticking a backup log in between each statement.  if you don't want the...

bcp out the data you want to keep, truncate the table and bulk insert it back in.