Viewing 8 posts - 1 through 8 (of 8 total)
Good question! 😀
Phil
Although all answers are replies, not all replies are answers.
Blog: http://philjax.wordpress.com
November 26, 2010 at 4:58 am
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...
Phil
Although all answers are replies, not all replies are answers.
Blog: http://philjax.wordpress.com
October 29, 2010 at 1:46 am
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...
Phil
Although all answers are replies, not all replies are answers.
Blog: http://philjax.wordpress.com
October 26, 2010 at 3:02 am
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...
Phil
Although all answers are replies, not all replies are answers.
Blog: http://philjax.wordpress.com
October 26, 2010 at 2:34 am
Nope - but not far from them
Phil
Although all answers are replies, not all replies are answers.
Blog: http://philjax.wordpress.com
October 8, 2010 at 4:15 am
Cobham, United Kingdom 😀
Phil
Although all answers are replies, not all replies are answers.
Blog: http://philjax.wordpress.com
October 8, 2010 at 2:57 am
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...
Phil
Although all answers are replies, not all replies are answers.
Blog: http://philjax.wordpress.com
June 28, 2009 at 6:02 am
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...
Phil
Although all answers are replies, not all replies are answers.
Blog: http://philjax.wordpress.com
June 27, 2009 at 5:03 pm
Viewing 8 posts - 1 through 8 (of 8 total)