We are swiftly running out of space on the drive(s) so this does need to be done.

The indexes will be rebuilt afterwards where necessary as a separate job step.

If that's...

I never said it was a good idea, I said it was one option to see if it improved things.

If it's only a select query you're running initially, try putting :-

set transaction isolation level read uncommitted

as the first line of your query. I've noticed it helps to alleviate...

I'm looking for a similar thing but can't get this to work.

Can anyone think of a reason why this won't work in 2008 R2?

Does it need any alterations to work...

A good week is when I've got some hair left at the end of it 🙂

But seriously, a little patience, a little learning and it's all good.

I have signed a contract but, probably like most people's, it's a little vague.

I like it that way.

I always make sure there's a line that basically reads "and anything other...