Changed MAXDOp to 1, rebuilt the indexes to INCLUDE the columns in the SELECT (I didn't actually have this in my index when I posted this question).

Arrghhh... sorted it. Now it runs in 23 seconds 😀

That makes perfect sense. Thanks for the clarification.

Check out this excelelnt website about creating a...

vs.satheesh (3/8/2013)

---

Hi

In my company we are using network nas storage.which i am able to share the folder in nas storage using user...

opc.three (3/6/2013)

---

To be fair, msdn scrips offer more than just the bare min and the licenses state that the software is there for 'dev use only.' This is to support...

Yea thanks guys. I'm going to install a named instance on each of the servers and start making the changes.

Once again, MS should make it clearer when it comes to...

I see what you mean thanks. I will play around with it and see how it goes.

select convert(varchar, cast('Feb 18 2013 3:35PM' as time), 100)

Sorry no, TDE is an enterprise edition feature only.

SET DATEFORMAT DMY

SELECT CONVERT(datetime, '25/02/12 11:39:34')

Yea and this is why one shouldn't attempt to answer question on the iPhone at 9pm after work 😛

Sure, just add another step in your existing SQL agent job and add some tsql along the lines of:

DELETE FROM incident WHERE DATEDIFF(YEAR,CAST(getdate AS DATE), created) >2

Maybe it's better if...

Yea that's a good point Grant.

Backup compression is also great for speeding things up.