Home Forums SQL Server 2008 SQL Server 2008 - General To sharpen the Query Logic RE: To sharpen the Query Logic

  • October 22, 2012 at 9:53 am

    #1551483

    sqlnaive (10/22/2012)

    Hi Brandie, Sean, ScottPletcher, I understand there can be no book on T-Sql which you can finish reading and say "Yeah, I'm the man now". It was just like, if there are any books on T-SQL puzzles for newbees, some SQL challenges which can enhance the SQl writing skills. There must be some authors for MS SQL Server who love to write SQL challenges for different scenarios.

    Gosh, if you want challenges, start answering questions on these forums.

    If you want some base method that can be expanded to solve various challenges, here's a link to a list of articles that can really help. I know the guy personally! 😉

    http://www.sqlservercentral.com/Authors/Articles/Jeff_Moden/80567/

    There are some great authors on the "Authors" link on the left side of the page. I'll also second Itzik Ben-Gan's books.

    Don't expect to get "smart" about it all overnight, though.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)