June 16, 2011 at 8:33 pm
Comments posted to this topic are about the item LoginProperties
June 16, 2011 at 9:27 pm
Thanks for easy question. As of now, correct answers % is 100 🙂
M&M
June 17, 2011 at 1:48 am
Maybe it is easy - but why not ask the 39% who've got it wrong at the moment...
June 17, 2011 at 1:54 am
Thanks Steve...
Thanks
June 17, 2011 at 5:47 am
Easy question! More one point!
June 17, 2011 at 5:53 am
The more of these questions I see, the more I think there are a significant fraction of respondents who are just clicking an answer at random...surely this isn't difficult enough to warrant the 40% incorrect rate?
June 17, 2011 at 7:15 am
SQL 2005 BOL doesn't list DaysUntilExpiration as an option. SQL 2008 BOL does. Might be why some people are missing it. (It's why I missed it anyway)
The Redneck DBA
June 17, 2011 at 7:16 am
paul.knibbs (6/17/2011)
The more of these questions I see, the more I think there are a significant fraction of respondents who are just clicking an answer at random...surely this isn't difficult enough to warrant the 40% incorrect rate?
Perhaps people should take some sort of DBA exam before they're allowed to answer the questions. 😉
I didn't know this and had to look it up. I've worked with data for 30 years but have never been a DBA or had to worry about this particular feature. I'm happy to have learned something that may come in handy later on but please dont assume that questions are easy for everybody just because they fall into your particular sphere of experience.
June 17, 2011 at 7:18 am
Richard Warr (6/17/2011)please dont assume that questions are easy for everybody just because they fall into your particular sphere of experience.
It doesn't--I had to look it up as well. Comparing the list in Books Online to the supplied options doesn't strike me as all that tricky, though (although I didn't know it was different in SQL 2005).
June 17, 2011 at 7:21 am
paul.knibbs (6/17/2011)
Richard Warr (6/17/2011)please dont assume that questions are easy for everybody just because they fall into your particular sphere of experience.
It doesn't--I had to look it up as well. Comparing the list in Books Online to the supplied options doesn't strike me as all that tricky, though (although I didn't know it was different in SQL 2005).
I actually just tried it in SQL 2005 and it works even though it's not in BOL. Go figure.
The Redneck DBA
June 17, 2011 at 7:45 am
These are referred to as 'undocumented features'. 😛
June 17, 2011 at 9:03 am
nice question
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 19, 2011 at 7:01 pm
paul.knibbs (6/17/2011)
The more of these questions I see, the more I think there are a significant fraction of respondents who are just clicking an answer at random...surely this isn't difficult enough to warrant the 40% incorrect rate?
One way of accounting for about 40% incorrect is to assume about 50% know the answer so they get it right, and the other 50% click at random (1 chance in 5) so altogether about 60% get it right.
Another way is to assume that about 100% thionk they know it but 40% of them are wrong (perhaps some have been misled by AQL 2005 BoL, which was incorrect from some fairly early stage onwards, but as of now only 8% have produced the answer that would suggest).
Probably neither of those extreme views is anywhere near right, though.
Tom
June 20, 2011 at 7:37 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 24, 2011 at 2:44 pm
I missed it because SQL 2005 help does not list DaysUntilExpiration. Should I always assume SQL 2008 as context for questions?
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply