Post reply

I'm new to SQL development..

  • September 28, 2014 at 10:07 pm

    #311218

    Hi There,

    I'm new to SQL development.. please assist me something that every developer must know & the performance perspectives. suggest me some links to read out and equip my self.

    Thanks in advance

  • September 29, 2014 at 3:17 am

    #1748738

    As a SQL developer, you should know how to develop TSQL of course.

    I can recommend the books written by Itzik Ben-Gan.

    Microsoft SQL Server 2012 T-SQL Fundamentals

    If you have more specific questions, we'll be glad to answer them.

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

  • September 29, 2014 at 9:33 am

    #1748860

    You could also try this basic tips: 45 Database Performance Tips for Developers.

    The book recommended by Koen is more complete, but this one can give you some basic performance principles on SQL.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • September 29, 2014 at 10:41 pm

    #1749028

    I would second both recommendations and add that you can't go wrong with any Itzek ben-Gan book.

    Learn what a tally table is; that has changed my career.

    This site is goldmine; take a look at the stairways and free pdf's.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

  • September 30, 2014 at 2:18 am

    #1749068

    If you are new then the books by Itzik Ben-gan are very good, the previously mentioned book, as well as Inside Microsoft® SQL Server® 2008: T-SQL Querying which can be found here http://www.amazon.co.uk/Inside-Microsoft%C2%AE-SQL-Server%C2%AE-2008/dp/0735626030

    for more advanced topics then look for books by Grant Fritchey who is also a regular on these boards.

    Finally simply come back to SSC and ask on the boards there are always a number of people willing to help and offer solutions. Just remember to follow posting rules, to get optimal help.

    _________________________________________________________________________
    SSC Guide to Posting and Best Practices

  • October 2, 2014 at 2:36 am

    #1749619

    Alan.B (9/29/2014)

    Learn what a tally table is; that has changed my career.

    +1000

    Good set based programming is what makes the difference between a good SQL developer and a great SQL developer.

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

Viewing 6 posts - 1 through 5 (of 5 total)

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