- Series: Developer Reference
- Paperback: 640 pages
- Publisher: Microsoft Press; 1 edition (April 26, 2006)
- Language: English
- ISBN-10: 0735623139
- ISBN-13: 978-0735623132
- Product Dimensions: 7.5 x 1.6 x 9 inches
- Shipping Weight: 2.6 pounds (View shipping rates and policies)
- Average Customer Review: 4.4 out of 5 stars See all reviews (34 customer reviews)
- Amazon Best Sellers Rank: #1,743,502 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Inside Microsoft SQL Server 2005: T-SQL Querying (Developer Reference) 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
Customers who viewed this item also viewed
Customers who bought this item also bought
From the Publisher
Key Book Benefits: -Delivers practical, hands-on guidance on sophisticated uses of T-SQL, including the differences between logical and physical processing, nesting of queries, and much more -Provides deep background information that helps developers optimize queries, aggregate data, and develop hierarchies and recursive queries -Helps promote mastery of T-SQL -Features numerous code and table examples, practical advice, logic puzzles, and best practices
About the Author
Dejan Sarka is a mentor with SolidQ and focuses on development of database and business intelligence applications. He is a frequent speaker at international conferences such as TechEd, SqlDevCon, and PASS. He is the founder of the Slovenian SQL Server and .NET Users Group. As main author or coauthor, Dejan has written nine books about SQL Server. He has also developed three courses for SolidQ: Data Modeling Essentials, Data Quality and Master Data Management, and Data Mining.
Itzik Ben-Gan is a mentor and cofounder of SolidQ. A Microsoft MVP for SQL Server since 1999, Ben-Gan teaches and consults internationally on T-SQL querying, programming, and query tuning. He is the author of Microsoft SQL Server T-SQL Fundamentals and coauthor of Inside Microsoft SQL Server: T-SQL Querying and Inside Microsoft SQL Server:T-SQL Programming. He has written numerous articles for SQL Server Magazine and MSDN, and speaks at industry events such as Microsoft TechEd, DevWeek, PASS, and SQL Server Connections.
Lubor Kollar is group program manager with the SQL Server Customer Advisory Team at Microsoft, working on the most challenging SQL Server deployments worldwide. He has 13+ years of experience with SQL Server development.
Browse award-winning titles. See more
If you are a seller for this product, would you like to suggest updates through seller support?
Top customer reviews
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!
The reason why the quality of books has risen is the expertise of the authors. For this book, the authors are either MS SQL MVP or have been involved with the creation of MS SQL at Microsoft.
Generally speaking, the book has high level expert description of the underlying MS SQL 2005 architecture and T-SQL commands. But it lacks a nice flowing writing style which hempers the understanding to a willing reader. This book is an another example of authors who are inept at explaining the subject matter which they are an expert much like a professor who can't teach.
I also felt some parts of the book were sloppy or not as detailed. For example, the authors state that one of the steps of T-SQL query tuning is the need to correlate wait stats with problematic queries. Yet they never provide an adequate example (other than providing a useless query of SYS.DM_OS_PERFORMANCE_COUNTERS table) of how to connect wait stat with a specific transaction. This is a huge missing link.
1)Awesome details on Indexes and Query plans
2)Solid advice on how to improve T-SQL for better performance.
1)Not for the beginners. The book goes straight to the harder subjects (PIVOT, APPLY, complex joins etc).
2)Does not cover simple or fundamental subject matters.
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.
Most recent customer reviews
This is a great reference or review text.Read more