When I took the exam there was one question where the conditions given eliminated all the of possible answers. So I picked the answer that violated just one...

I feel that one of the terms that should be banned is "snapshot backup." The term "backup" implies that as long as you have the backup file, you'll...

So this curriculum (6231A) is in error. For one thing, it calls it "High Protection Mode" rather than High Safety. This is described as not using a witness...

If all the queries in combined by the UNION statement are quering the same table (or differenet tables but the coumn names are the same), then you shoudn't need to...

Ed, were your non-troublesome upgrades from 2008 R2 to 2012 done by ungrading existing instances, installing new names-instances side by side and migrating the DBs or by migrating DBs...

My guess is that the upgrade was not completed on the passive node, and a 2008 Master database cannot launch on a 2005 server.

Go to C:\Program Files\Microsoft SQL Server\100\Setup...

Reinstalling SQL Server (and compenents apparently) can be tricky following an unistall.

Try this:

1) Remove all SQL components using the Setup program & Add/Remove Programs.

2) Delete the Microsoft SQL Server folder...

I know there's no hard & fast rule what the log file size should be relative to the DB file size, but a log file 60% of the data file...

This is the second time? If you shrink a database at all, it should be one-off job following a one-off large data deletion. If it grows "too large"...

Sorry to be blunt but if you're asked these question in a job interview and you cannot address them (after some followup questions because some of them are vague), than...

I would say anthing with at least 12GB of RAM. That way you can run VMs for a domain controller and two cluster nodes without having to wait...

Interesting... So a 2-Node failover cluster can host multiple default instances (using separate network names & IPs & drives). Can a single clustered Network resource contain a...

Is there a distinction between a default instance and a named instance in clustered SQL installations? I don't think so, because a clustered instance always uses a network...

I have not tried this. But I have uninstalled non-clustered SQL Server and was not able to reinstall until I had deleted the C:\Program Files\Microsoft SQL Server folder...

Are there any messages suggesting a problem with "Heartbeat"? Or network connectivity isseus on the passive node in general? Heartbeat is a special network connection between the two nodes...