Hi Steve,

Yes - I did try all those things.

- Completely uninstalled 2008R2 and re-installed it. This failed as above.

- Completely uninstalled 2008R2 and tried to replace it...

This is Windows 7 Pro

GSquared - thanks for your reply. Yes, I was mulling over exactly that scenario on the train on the way home this evening. I think that's my only...

Yes, looks like my expectations for the likely fragmentation in this table were completely wrong. It's 98.9% fragmented at the leaf level in the clustered index (across all partitions),...

Thanks again for the reply Jeff.

I didn't actually ask why the copy to the heap was faster. In fact, the copy takes roughly the same length of time as...

Thanks for the suggestions so far.

Michael - sadly, it simply isn't practical to re-organize the index on such a large table. I know it's partitioned, but the SAN behind...

Paul,

Regarding the worktable, it isn't a #table worktable, just a simple, heap local table in the database.

No reason why the table couldn't be dropped, clearly. In my defence, the code was written long before my time (that old excuse again ! 🙂 ) . ...

I'd run profiler (filtering on the target table and log tables) just to verify that the expected commands are being executed.

Set profiler to capture any ROLLBACK statements and errors/exceptions

Does your...

Yes you can do all those. Try experimenting with the wizard - you'll soon find out all the options

This is really tricky to get the information you want without using a 3rd party product. There are several of these on the market (e.g. Lumigent Log Explorer, Redgate...

In SSMS, in the object explorer, right-click on the database name and select Tasks -> Generate Scripts ...

This is equivalent to the "Generate SQL Script" wizard in SQL2000, and allows...

Hi,

For the query you give as an example, on the face of it you would probably gain only a modest gain in performance. However, since you are executing this...

Hmmm - no

Forgive me, but this sounds a little impractical, unless you were just suggesting this as a test to prove a...

That "degraded performance" though, Colin, could be far less than the degraded performance resulting from NOT having the correct plan. I'm not suggesting you should recompile every SP routinely,...