Like these sorts of questions the ones where you go I know this, then take a step back and do the reading due to that niggle of doubt that creeps...

Richard, why not setup a number of users for each type of access one for datareaders, one for writers etc. This breaks out the granularity and allows you to limit...

One of those you know, but then think actually is it, has something changed that I've not noticed.  I like these sorts of questions.

Could you not achieve a lot of this more efficiently with a Merge statement ?

Marker

I know what he means about the vegetable soup. I came to the realisation a while back that you can't know it all, when you have 6 different applications all...

What wait types are you seeing (any I/O related) and what does sp_locks tell you about the locking on the server at this time. Could be related to a large number...

Finally an R question I knew without research. Still amazed at the power of the R language to automate some data cleansing jobs we've been working through.

Hang on should have read that fully. So you stopped the SQL Service ? did you confirm which node was Active at the time you did this ? stopping the...

Will depend on the dependancies within the cluster. If that service is high in the dependency list which I would hope it is, then the failure or stopping of the...

Brandie think they call this 3rd party syndrome here. Seems to be indicative of the way they work, if it wasn't written into the contract there is no need for...