The cluster service is the service that is in charge of the failover. It will perform a failover if it detects an issue, so in order to test this you...

If you stop the cluster service - it wont failover!

The round robin definately does not apply to log files - they are used serially.

This is a really good article on working with and speccing tempdb. It is for 2005 but is still relevant for 2008. It also has some good diagnostic scripts.

Thank you.

But how do we get Sub_ID in the select list?

Do you want the lowest price for each unique MasterID (in which case your output should include 1235 cc 4) or do you want the lowest price...

Not to mention the coolest SSC avatar 🙂

Congratulations.

I don't know - looks sketchy though.

Good puzzler - thanks. Nice coverage of different scenarios.

exec sp_configure 'show advanced options',1;

go

reconfigure;

go

EXEC sp_configure 'xp_cmdshell', 1;

go

reconfigure;

go

I think 450 follows quite naturally from 432. It seems to take a deeper - higher level approach to DBA work. Think architectural more than in the trenches admin...

From what...

In other words use set rather than select to assign to the variable in this case - assuming that you want a null assigned if that was the result. If...

These sites deal with the behaviour where nulls are concerned.

http://ryanfarley.com/blog/archive/2004/03/01/390.aspx

http://vyaskn.tripod.com/differences_between_set_and_select.htm

But cold coffee is right as well - if you want granular control over what is returned...

Are you wanting to pass in file number as a parameter or will the sproc iterate through all file numbers?