I have read that if autogrowth is set to a %, tempdb grows at 10% of the initial size. I always want to make sure this, but BOL doesn't explicitly specify it. Can...

I agree with everyone that the 4 answers are all correct, and I was actually hoping to see an option for "All of the above". I suggest this question to...

I had moved some hugh databases across 2 continents, also the downtime cannot be too long. What I did was

1) Transmit the regular full backups to the new server

2)...

Thanks for your suggestions, Jimmy. I do ensure that the servers are in pink health, the CPU and memory are all fairly utilised. To address your questions: 1) The number...