Good question! 😀

I have found that DBAs that have worked alone for a while generally think that they are quite advanced, because in reality, they have had no-one to mentor them; and...

To create a new identifier (or as I view it, reset service broker) for a restored database, yes, I would use the NEW_BROKER. However the question could have been phrased...

I'm sorry, but I do not believe that the question was phrased very well. To 'enable' Service Broker for the database, you use the ENABLE_BROKER option, as stated in the...

Nope - but not far from them

Cobham, United Kingdom 😀

Absolutely correct, there are no specific threads that write or read from disk. Perhaps I over simplified my explanation. The size of the data files I spoke of were not...

1 data file per cpu is definately a great idea, the reason for this is for parallel writes i.e. 4 cores, 4 threads, all write at the same time, instead...