Post reply

T-SQL Book

  • December 29, 2008 at 10:07 am

    #197972

    Hello,

    Can anyone recommand me some good T-SQL book?

    Thanks a lot,
    Hary

  • December 29, 2008 at 10:29 am

    #918461

    Itzik Ben-Gan has three that I highly recommend:

    SQL Server 2008 T-SQL Fundamentals - It's 2008, yes, but it's very introductory and applies almost completely to 2005.

    Inside SQL Server 2005: T-SQL Querying. The first chapter alone should be required reading before anyone is allowed to touch TSQL

    Inside SQL server 2005: T-SQL Programming. Good information.

    Joe Sack also has some great books on TSQL.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • December 29, 2008 at 10:40 am

    #918474

    Thanks a lot. I really appreciate that.

    Thanks a lot,
    Hary

  • December 29, 2008 at 11:12 am

    #918491

    I have a copy of SQL Server 2005 T-SQL Recipes (Wrox) that has tons of code samples for just about everything. The samples are really basic though, but give you enough to get rolling. When I forget the syntax of PIVOT, that's where I go.

  • December 30, 2008 at 6:42 am

    #918995

    not a T-SQL book per se but I use Programming SQL Server 2005 by Stephen Forte (hey Steve!) a lot

    he is very active in the New York City .NET User Group

  • December 30, 2008 at 7:23 am

    #919035

    The Guru's Guide to Transact-SQL, by Ken Henderson.

  • December 30, 2008 at 7:30 am

    #919038

    Larry Larson (12/30/2008)

    The Guru's Guide to Transact-SQL, by Ken Henderson.

    I agree with this. I have three of Henderson's books sitting on my shelf right now. Unfortunately, they're beginning to age and, except for the fundamentals, become less and less relevant.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • December 30, 2008 at 8:04 am

    #919055

    I agree with the "Inside SQL Server" series mentioned above. After being a SQL DBA for 13 years & getting certified, I discovered these books. I'm somewhat chagrined at how much I found that didn't know and learned.

  • December 30, 2008 at 8:07 am

    #919057

    Tony (12/30/2008)

    I agree with the "Inside SQL Server" series mentioned above. After being a SQL DBA for 13 years & getting certified, I discovered these books. I'm somewhat chagrined at how much I found that didn't know and learned.

    Also adding a recommendation for the "Inside SQL Server" series. I think these should be mandatory reading, as once you have an understanding of how SQL server stores and retrieves data it becomes obvious why things like cursors or any row-processing is a bad idea.

  • December 30, 2008 at 2:19 pm

    #919304

    Gurus'.. I can't Thank you enough.

    Thanks a lot,
    Hary

  • December 31, 2008 at 9:00 am

    #919703

    My favorite series on the subject is "The SQL Server Bible", by Paul Nielsen. Those are what got me from "what's a database and why are they called 'relational'?", to being a competent DBA.

    - 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

  • December 31, 2008 at 9:22 am

    #919715

    Paul has a good book, though I think I like the Inside SQL Server series better.

  • January 9, 2009 at 9:18 am

    #924303

    For a good beginner's guide you can't do much better (IMHO) than:

    "SQL Queries for Mere Mortal" by Viescas Hernandez,

    Jason

    ___

Viewing 13 posts - 1 through 12 (of 12 total)

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