There is something to be said about actually having a book in hand, maybe it is a bit old school, but I do like having the actual book. However,...

I agree, Multi Server administration was available pre-2008 r2. However, what is new is the SQL Server Utility for managing performance data and management policies.

http://msdn.microsoft.com/en-us/library/bb500435.aspx

So...

I ran query 1 and query 4 on two tables. One table had 183 rows and the other had 9,886,862 rows. On the first table, query one had...

I think it is a good practice to backup the Master, MSDB and Model databases on a regular basis. Of the three, the Model is the least important unless you...

Misleading question. Should have said "New Query" not SSMS. Despite that, I learned about this feature from the responses to the poor question. Thanks!!!

Good questions..and thanks to the comments a much more detailed explaination was provided!!

Had to think about this question for a bit. I have never worked with Policy Based Management, so this question helped to learn about.

Please check the answers before posting a question. People use the QofD as a way to learn or to refresh the memory on a given topic. Bad and...

I agree, a forth option of 1-Boston;2-New Delhi would have made the question better. With a forth option, I would have had to think more about the impact...

More of these types of questions please! Good way to start the day.

Always good to have a refresher on transaction basics! Thanks

Nice Question!

Great Question!!