Publication Date:March 29, 2006 Availability:Usually ships in 1-2 business days
Features:
•
ISBN13: 9780735623132
•
Condition: New
•
Notes: BUY WITH CONFIDENCE, Over one million books sold! 98% Positive feedback. Compare our books, prices and service to the competition. 100% Satisfaction Guaranteed
Product Description This thorough, hands-on reference for database developers and administrators delivers expert guidance on sophisticated uses of Transact-SQL (T-SQL)one of the most familiar and powerful programming languages for SQL Server. Written by a T-SQL guru, this guide focuses on advanced querying techniques and how queries are interpreted and processed by the SQL Server execution engine. Youll get in-depth coverage of the sophisticated uses of T-SQL, including the differences between logical and physical processing, nesting of queries, and much more. The book explains and compares solutions to database-development problems in both SQL Server 2000 and SQL Server 2005, discussing the new T-SQL programming features added to SQL Server 2005 in detail. Includes extensive code samples, table examples, and logic puzzles to help database developers and administrators understand the intricacies and help promote mastery of T-SQL
Enough said... Incredible book!March 31, 2010 Rouben Gargaloyan(California, USA) The reviewers before me elaborated enough about this amazing book, so I don't have much to add. This book deserves nothing but 5 stars and I don't understand reviewers giving it less than 5... If one codes in SQL (level is not relevant) he must have this book right next to him all the time (forgive my sexism). Some solutions in this book (like aggregations using XPATH) are screamingly elegant and effective. I very much admire the organization of the book: from problem definition to solution, in easy to follow format. This book totally turns you away from google's search bar and makes you praise every penny you spent on it. Great job, Itzik!
DisappointedFebruary 6, 2010 Softie Developer(Canada) Very limited coverage. Nothing about date processing. I have better luck just doing a Google search on whatever it is I'm looking for.
greatnessOctober 22, 2009 nope(United States) this is one of the best books i have ever read on SQL server.
highly recommended to the enthusiast. not so much for the beginner/intermediate.
i have read it cover to cover more than once. if you are reading this review(and then you should be buying this book) and are still looking for another great author check out some of the stuff by ken england. i have only read his sql 2000 tuning book, but this book by itzik et al and that one are at the top of my fave's list. and i have heard from reliable friends that england's 2005 version was equally on point. also, didnt think the t-sql programming book was quite upto the level of this one. it was kinda like if you enjoyed this one on querying (especially that monster chapter on tuning - 130pages along with the first chapter on the "order of operations") then you already know 75+% of whats in the t-sql programming book. if that doesnt make sense to you, then buy the t-sql programming book. its got a ton of good stuff in it.
in conclusion, i am waiting to see what itzik (and delaney for that matter - check out sql 2008 internals) releases next for sql 2008. cheers.
Great reference!May 21, 2009 Paul A. Hernandez(TX USA) If you need great background information about the best way to write queries and stored procedures for SQL server 2005 then this is a great book. Lots of detail on not only how but they why that many books leave out so that you understand why best practices are the way they are.
Fantastic in every wayMay 20, 2008 Joshua Huber(Burbank, CA United States) 3 out of 4 found this review helpful
As a programmer we go through many a book. And many of them read and feel like textbooks. So we skim, read in short bursts, simply would rather avoid the read.
This book is so well written that it can't be put down. And it's packed with REAL WORLD examples. Instead of just defining syntax and using a lame example, this book goes FAR beyond that, and digs deep into real world examples that really shine a light on your work.
I purchased this book almost a year ago, and it's still one of the most referenced books I have. I am constantly pulling it out when I reach a problem in my work, and this book always has great pointers to a solution.
This book will make you a T-SQL junkie, get it.
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.
