Post reply

LoginProperties

  • June 16, 2011 at 8:33 pm

    #75598

    Comments posted to this topic are about the item LoginProperties

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • June 16, 2011 at 9:27 pm

    #1340168

    Thanks for easy question. As of now, correct answers % is 100 🙂

    M&M

  • June 17, 2011 at 1:48 am

    #1340222

    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

    #1340223

    Thanks Steve...

    Thanks

  • June 17, 2011 at 5:47 am

    #1340334

    Easy question! More one point!

  • June 17, 2011 at 5:53 am

    #1340339

    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

    #1340387

    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

    #1340390

    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.

    _____________________________________________________________________
    MCSA SQL Server 2012

  • June 17, 2011 at 7:18 am

    #1340395

    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

    #1340397

    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

    #1340431

    These are referred to as 'undocumented features'. 😛

  • June 17, 2011 at 9:03 am

    #1340507

    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

    #1340934

    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

    #1341190

    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

    #1343928

    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