Are the posted questions getting worse?

  • Lynn Pettis (11/3/2011)


    Well, my daughter Kirisa was just inducted into the National Honor Society ths evening!

    Awesome! (I sense a very proud papa...)

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes


    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • Anybody have new ideas over here?

    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

  • Cadavre (11/4/2011)


    Brandie Tarvin (11/4/2011)


    SQL Kiwi (11/4/2011)


    So, it depends

    Someone so needs to come up with an interview question where this is the exact answer that's needed.

    Isn't that pretty much every interview question relating to SQL Server?

    Yes - though it's the explanation of why it depends, what it depends on, and what it means in practice that matters.

  • Cadavre (11/4/2011)


    Brandie Tarvin (11/4/2011)


    SQL Kiwi (11/4/2011)


    So, it depends

    Someone so needs to come up with an interview question where this is the exact answer that's needed.

    @=)

    Isn't that pretty much every interview question relating to SQL Server?

    The answer is never just 'It depends.'. The answer can start (or end) with 'It depends', but has to include what it depends on.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Cadavre (11/4/2011)


    Brandie Tarvin (11/4/2011)


    SQL Kiwi (11/4/2011)


    So, it depends

    Someone so needs to come up with an interview question where this is the exact answer that's needed.

    @=)

    Isn't that pretty much every interview question relating to SQL Server?

    No - i have some very specific questions about query plan operators.

    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

  • SQLRNNR (11/4/2011)


    Anybody have new ideas over here?

    Rebuild master, then once SQL's running, restore system backups or replace rebuild system database files with the old system files (ensuring that the directory actually exists this time)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • SQL Kiwi (11/4/2011)


    Yes - though it's the explanation of why it depends, what it depends on, and what it means in practice that matters.

    GilaMonster (11/4/2011)


    The answer is never just 'It depends.'. The answer can start (or end) with 'It depends', but has to include what it depends on.

    Agreed and agreed 🙂


    Forever trying to learn
    My blog - http://www.cadavre.co.uk/
    For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
    For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • GilaMonster (11/4/2011)


    SQLRNNR (11/4/2011)


    Anybody have new ideas over here?

    Rebuild master, then once SQL's running, restore system backups or replace rebuild system database files with the old system files (ensuring that the directory actually exists this time)

    Thanks. I didn't want to make this suggestion without a second opinion. Now I have it.:cool:

    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

  • SQLRNNR (11/4/2011)


    Cadavre (11/4/2011)


    Brandie Tarvin (11/4/2011)


    SQL Kiwi (11/4/2011)


    So, it depends

    Someone so needs to come up with an interview question where this is the exact answer that's needed.

    Isn't that pretty much every interview question relating to SQL Server?

    No - i have some very specific questions about query plan operators.

    Ask one. I bet I can start an answer with 'it depends'...:cool:

  • SQL Kiwi (11/4/2011)


    SQLRNNR (11/4/2011)


    Cadavre (11/4/2011)


    Brandie Tarvin (11/4/2011)


    SQL Kiwi (11/4/2011)


    So, it depends

    Someone so needs to come up with an interview question where this is the exact answer that's needed.

    Isn't that pretty much every interview question relating to SQL Server?

    No - i have some very specific questions about query plan operators.

    Ask one. I bet I can start an answer with 'it depends'...:cool:

    What is the capital of Alaska?

    Oh wait, you meant for query plan operators.

    What is this query plan operator?

    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

  • GilaMonster (11/4/2011)


    Cadavre (11/4/2011)


    Brandie Tarvin (11/4/2011)


    SQL Kiwi (11/4/2011)


    So, it depends

    Someone so needs to come up with an interview question where this is the exact answer that's needed.

    @=)

    Isn't that pretty much every interview question relating to SQL Server?

    The answer is never just 'It depends.'. The answer can start (or end) with 'It depends', but has to include what it depends on.

    Unless the interview question were something like:

    What's the most common caveate a DBA will give you in response to technical questions about databases?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • SQLRNNR (11/4/2011)


    Oh wait, you meant for query plan operators.

    What is this query plan operator?

    Alien ship attacking Beijing skyscraper?

  • Steve Jones - SSC Editor (11/4/2011)


    SQLRNNR (11/4/2011)


    Oh wait, you meant for query plan operators.

    What is this query plan operator?

    Alien ship attacking Beijing skyscraper?

    Correct. When can you start?

  • Steve Jones - SSC Editor (11/4/2011)


    SQLRNNR (11/4/2011)


    Oh wait, you meant for query plan operators.

    What is this query plan operator?

    Alien ship attacking Beijing skyscraper?

    That is the only acceptable answer.

    Would you believe somebody once said it was Godzilla in the New York Hilton?

    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

  • SQL Kiwi (11/4/2011)


    Steve Jones - SSC Editor (11/4/2011)


    SQLRNNR (11/4/2011)


    Oh wait, you meant for query plan operators.

    What is this query plan operator?

    Alien ship attacking Beijing skyscraper?

    Correct. When can you start?

    It depends - how much does it pay?

    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

Viewing 15 posts - 31,411 through 31,425 (of 66,712 total)

You must be logged in to reply to this topic. Login to reply