Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Database Mirroring Failover Expand / Collapse
Author
Message
Posted Thursday, October 13, 2011 5:57 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, April 27, 2014 7:45 PM
Points: 1,589, Visits: 253
Thanks for the straightfroward question. I needed the point.

http://brittcluff.blogspot.com/
Post #1189751
Posted Thursday, October 13, 2011 6:48 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 1:28 PM
Points: 1,264, Visits: 3,594
I read it a few times trying to find the trick.
Apparently not a "ah ha! gotcha!" question.


______________________________________________________________________________________________
Forum posting etiquette. Get your answers faster.
Post #1189782
Posted Thursday, October 13, 2011 8:14 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 9:24 PM
Points: 17,807, Visits: 15,728
L' Eomot Inversé (10/13/2011)
Nice easy one today.

But the 17% mentioned above has gone up to 22% now.

Surprised that 60 people (22%) so far got it wrong; even people who don't know the answer should have been able to apply simple reasoning to see which of the four options has to have a witness. (Maybe seeing some of the bizarre decisions made by the designers of SQL/T-SQL discourages people from trying to use logic to get the answer?)


Simple reasoning indeed. Half of the answer was given in the question immediately eliminating any options that did not say "High Safety" then it becomes pretty easy after that.

Still sitting at 22% incorrect though with 97 respondents answering incorrectly.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1189875
Posted Thursday, October 13, 2011 8:23 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:53 AM
Points: 1,176, Visits: 778
nice question - tks
Post #1189889
Posted Thursday, October 13, 2011 9:56 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, October 11, 2013 8:39 AM
Points: 58, Visits: 606
Thanks for the question Steve.

It was one of those nice ones where I knew the answer, but thought, hmmm, is there a trick to this.

Made me think a little, but I got it right, guess I should trust my gut feeling a little more.

Nic
Post #1189999
Posted Thursday, October 13, 2011 1:01 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 11:29 AM
Points: 3,354, Visits: 2,001
Nice question, thanks!
Post #1190137
Posted Thursday, October 13, 2011 1:37 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, September 25, 2013 6:23 AM
Points: 392, Visits: 405
Nice question on Datbase mirroring

===========================================
Better try and fail than not to try at all...

Database Best Practices

SQL Server Best Practices
Post #1190167
Posted Tuesday, October 25, 2011 11:49 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:33 AM
Points: 13,247, Visits: 11,025
Great question, but I got it wrong because I mistakenly read "without" as "with".
Me need more coffee!




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1196081
Posted Monday, August 6, 2012 1:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 25, 2014 4:37 AM
Points: 8, Visits: 72
Easy question. Thanks
Post #1340385
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse