Suggestions for new SQL book.

  • Performance tuning is good for everybody. Though there are other things to consider when looking to tune reports besides just the tsql.

    I would also recommend my book 😉

    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 (6/27/2014)


    Performance tuning is good for everybody. Though there are other things to consider when looking to tune reports besides just the tsql.

    I would also recommend my book 😉

    Which book is that SQLRNNR so I can look it up? Love reading the SQL books.:-)

    I'll Probably then order Query Tuning today since you said its good for everyone. I wonder if I could get Grant to autograph it:-P

    ***SQL born on date Spring 2013:-)

  • thomashohner (6/27/2014)


    SQLRNNR (6/27/2014)


    Performance tuning is good for everybody. Though there are other things to consider when looking to tune reports besides just the tsql.

    I would also recommend my book 😉

    Which book is that SQLRNNR so I can look it up? Love reading the SQL books.:-)

    I'll Probably then order Query Tuning today since you said its good for everyone. I wonder if I could get Grant to autograph it:-P

    http://www.amazon.com/Server-2012-T-SQL-Recipes-Problem-Solution/dp/1430242000

    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

  • Oh and FWIW - I am sure Grant will autograph the book. You see him doing that sort of thing at all sorts of events.

    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 (6/27/2014)


    Oh and FWIW - I am sure Grant will autograph the book. You see him doing that sort of thing at all sorts of events.

    Nice! SQLRNNR thanks for the recommendations. I know it says its for 2012. So its probably got a lot of the new 2012 functions in there, but by chance do some of your recipe's work for 2008? Also would you be willing to autograph a copy? I'm a nerd.

    ***SQL born on date Spring 2013:-)

  • Many of the recipes work on 2008. There is some functionality that did not change with the 2012 release.

    And yes, if we cross paths I can autograph it.

    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

  • Sounds like a purchase. Going to order it then, can't wait to read it! Thanks Jason:-D

    ***SQL born on date Spring 2013:-)

  • You are welcome and thank you.

    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

  • I purchased Grant's book "SQL Server 2008 Query Performance Tuning Distilled" and liked it.

  • I'm getting that as well I actually decided to do both those and another one I stumbled on. So I will have 3 new books that should keep me busy for awhile. I see books as great investments:-)

    http://www.amazon.com/gp/product/1430234881/ref=oh_details_o00_s00_i00?ie=UTF8&psc=1

    ***SQL born on date Spring 2013:-)

  • If you're interested in query tuning, you might want to hold off purchasing a little while. I should have my 2014 update of the query tuning book done within a couple of weeks. It's completely restructured so it should be more readable. Plus all new material on bad parameter sniffing, in-memory oltp, cardinality estimation and natively compiled procedures.

    "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

  • Grant Fritchey (6/30/2014)


    If you're interested in query tuning, you might want to hold off purchasing a little while. I should have my 2014 update of the query tuning book done within a couple of weeks. It's completely restructured so it should be more readable. Plus all new material on bad parameter sniffing, in-memory oltp, cardinality estimation and natively compiled procedures.

    You're doing it wrong, you're supposed to let him buy the old one, then tell him how much better the new one is, and give him a discount. Or tell him support for the old version has been discontinued, and he must upgrade in order to receive his premium autographed copy.

    or something like that.

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • jcrawf02 (7/1/2014)


    Grant Fritchey (6/30/2014)


    If you're interested in query tuning, you might want to hold off purchasing a little while. I should have my 2014 update of the query tuning book done within a couple of weeks. It's completely restructured so it should be more readable. Plus all new material on bad parameter sniffing, in-memory oltp, cardinality estimation and natively compiled procedures.

    You're doing it wrong, you're supposed to let him buy the old one, then tell him how much better the new one is, and give him a discount. Or tell him support for the old version has been discontinued, and he must upgrade in order to receive his premium autographed copy.

    or something like that.

    Behave like Microsoft you mean? But I work for Red Gate. We're a nice evil profit seeking corporation.

    "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

  • jcrawf02 (7/1/2014)


    Grant Fritchey (6/30/2014)


    If you're interested in query tuning, you might want to hold off purchasing a little while. I should have my 2014 update of the query tuning book done within a couple of weeks. It's completely restructured so it should be more readable. Plus all new material on bad parameter sniffing, in-memory oltp, cardinality estimation and natively compiled procedures.

    You're doing it wrong, you're supposed to let him buy the old one, then tell him how much better the new one is, and give him a discount. Or tell him support for the old version has been discontinued, and he must upgrade in order to receive his premium autographed copy.

    or something like that.

    Haha, I'd probably do it too! I will wait on the new one. I'll read the other two I got while waiting. Love my SQl books. So far one of my favorites is Itzik Ben-Gan's T-SQl Fundamentals though sometimes his writing can be hard to read. I have had many aha moments while drinking my coffee and turning the pages.

    @Grant is it available for preorder or wish list?

    ***SQL born on date Spring 2013:-)

Viewing 15 posts - 1 through 15 (of 15 total)

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