Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning) |  | Authors: Itzik Ben-Gan, Lubor Kollar, Dejan Sarka
Publisher: Microsoft Press
List Price: $44.99
Buy New: $5.37
as of 11/22/2009 01:24 CST details
You Save: $39.62 (88%)
New (43) Used (20) from $5.35
Seller: bookoutlet1
Rating:  31 reviews
Sales Rank: 32816
Media: Paperback
Pages: 632
Number Of Items: 1
Shipping Weight (lbs): 2.7
Dimensions (in): 8.8 x 6.9 x 1.6
MPN: 9780735623132
ISBN: 0735623139
Dewey Decimal Number: 005.7565
EAN: 9780735623132
ASIN: 0735623139
Publication Date: April 26, 2006
Availability: Usually ships in 1-2 business days
| |
| Also Available In:
|
| Similar Items:
| |
| Editorial Reviews:
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
|
| Customer Reviews:
Showing reviews 1-5 of 31
 greatness October 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 way May 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.
PS The logic puzzles in the back are great, too!
 Excellelent Intermediate or review February 10, 2008
Daniel C. Kline (West Bend, WI)
Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning)
This is a great reference or review text. The content is fairly meaty and will take some chewing. For example, the book starts right off by breaking down the query engine process into it's processing steps and taking the reader through examples of the result sets at each step in the process. It might be overwhelming for someone starting out, but it's a great place to dive into a deeper understanding of the data engine.
An excellent contribution to the "Inside-SQL" series October 8, 2007
Matthew Bryde (Australia)
5 out of 5 found this review helpful
This is the 2nd book of the 4 part "Inside-SQL" series, with each book I imagine, appealing to a different reader. Having a programming background, I enjoyed this book more than the first in the series ("The Storage Engine"), which on it's own is also an excellent book.
As mentioned in other reviews, this book is definitely not for beginners. The authors assumes a basic level of SQL knowledge from the reader as he launches into complex Transact-SQL examples - unlike most books which start the reader with simple SQL examples and progress through to complex ones.
While reading this book, it was easy to compare it's contents with Ken Henderson's popular "A Guru's Guide to Transact-SQL", with the latter book becoming more and more outdated by the improvements in Transact-SQL since it was published. If you're a fan of Henderson, you will quickly become a fan of Itzik.
A benefit of this book is that unlike most SQL 2005 books, this is not an update on SQL 2000 material, but instead starts at the 2005 level. The author focuses on the new syntax introduced in SQL 2005, and then, moves onto older SQL 2000 syntax and compares both the complexity and the performance differences between the two. This itself is invaluable to those of use that code in Transact-SQL and feel more comfortable using the "old ways". This book highlights how the new syntax is in fact simpler and more efficient - we just need to take the time and effort to understand and become familiar with the new language changes.
The book starts by discussing the logical processing of a SELECT statement, which helps the reader to understand the hows and whys of writing a query. I finally understood why I can't use an expression's alias in a WHERE BY or GROUP BY clause (as the SELECT line is one of the last parts of the statement to be processed). Throughout the book, the author often defines a problem and allows the reader to formulate an appropriate solution. He then reveals MULTIPLE solutions and explains why each is good or bad. The book ends with a selection of "logic puzzles" that test the reader's ability to solve logical problems. This was both fun and informative.
After reading this book, I found myself changing the way I constructed SQL queries at work - for the better!
Showing reviews 1-5 of 31
|
|
|
|
