• Stewart "Arturius" Campbell (2/14/2013)

    Good back-to-basics question, thanks Lokesh

    +1. Had to think for a second about it... which is about all I have in thinking power today anyway. 🙂

    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

  • Good question, had to think a bit.

    Stupid me, scratching my head: what is that extra "databasename#" argument doing there?

    I always use the (unnecessary) "As" when aliasing columns, b/c otherwise I..... scratch my head reading code. 😀


  • Great question to end the week and go into a three-day weekend. Thanks.

  • Thanks for the question

    Jason...AKA CirqueDeSQLeil
    I have given a name to my pain...MCM SQL Server, MVP
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Thanks for that


  • Nice question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • A good quetion, although I had to make an (educated?) guess.

    Thanks, Lokesh!

  • Good question. I just guessed that it could be the case and bingo. I was on right track. 🙂

  • nice question.... 🙂


    Go fast as possible

    You cannot get to the top by sitting on your bottom.

  • I am proud of my "wrong" answer - I answered correctly despite cleary seeing the question was missing an assumption. Who in their right minds would work on an instance having an AdventureWorks2008 database unless coerced forcibly?

Viewing 10 posts - 16 through 24 (of 24 total)

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