Depends on the db usage - mine was used 24/7 with 20million site users so I needed to spread the load out -

and deleting 50m rows in a single...

I found a nice calm way to delete specific chunks of 200,000+ rows from a table, getting around the mass-logging issue you would run into if you just ran "delete...

Definitely get references, but make sure they're for work in a similar context and data volumes. There's a world of difference between backoffice systems and online data used 24/7.

Quite a...

Thank you for the helpful replies it seems like the concensus is 'it depends'.

Rather than my describing a single theoretical context,

has anyone actualy hired a consultant to advise on SQL...