Enter your mobile number 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.
Getting the download link through email is temporarily not available. Please check back later.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your mobile phone number.

Inside Microsoft SQL Server 2005: T-SQL Querying (Developer Reference) 1st Edition

4.6 out of 5 stars 35 customer reviews
ISBN-13: 978-0735623132
ISBN-10: 0735623139
Why is ISBN important?
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
Buy used On clicking this link, a new layer will be open
$7.00 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$44.99 On clicking this link, a new layer will be open
More Buying Choices
26 New from $6.00 60 Used from $0.01 1 Collectible from $9.85

There is a newer edition of this item:

Free Two-Day Shipping for College Students with Prime Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student

Windows 10 For Dummies Video Training
Get up to speed with Windows 10 with this video training course from For Dummies. Learn more.
$44.99 FREE Shipping. Temporarily out of stock. Order now and we'll deliver when available. We'll e-mail you with an estimated delivery date as soon as we have more information. Your account will only be charged when we ship the item. Ships from and sold by Amazon.com. Gift-wrap available.
click to open popover

Frequently Bought Together

  • Inside Microsoft SQL Server 2005: T-SQL Querying (Developer Reference)
  • +
  • Inside Microsoft SQL Server 2005: T-SQL Programming (Developer Reference)
Total price: $89.98
Buy the selected items together

Editorial Reviews

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.


New York Times best sellers
Browse the New York Times best sellers in popular categories like Fiction, Nonfiction, Picture Books and more. See more

Product Details

  • 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.6 out of 5 stars  See all reviews (35 customer reviews)
  • Amazon Best Sellers Rank: #300,685 in Books (See Top 100 in Books)

Customer Reviews

Top Customer Reviews

By Grant Fritchey VINE VOICE on December 20, 2006
Format: Paperback
This will be a standard book on most DBA's desktops. Itzik Ben-Gan of Solid Quality Learning has taken the Advanced T-SQL course that he teaches and turned it into a fantastic book.

The first two chapters cover the logic of query processing and what physically occurs when you run a query. Very early on Itzik establishes a practice of defining a problem or a question about T-SQL and then spends time working through the solution. This approach carries through the entire book. This not only allows the user to see the problem solving approach in action, but enables the user in pursuing the solutions themselves. Itzik takes the time to lay out a very detailed methodology for identifying and tuning problem queries from the server, through the database, down to the query that's causing the problems. From these foundation chapters he explores topics such as Subqueries and Table Expressions, Joins and Set Operations, Aggregating and Pivoting Data, Top and Apply, Data Modification and finally Graphs, Hierarchies and Recursive Queries.

The greatest thing about the book is that Itzik really explores his solutions. He walks the user into a mind set that accepts only set based operations as the norm for data access. He shows multiple solutions to many of the problems and outlines where and how those solutions differ. This book acts as a good mechanism for actually learning the details of how to use T-SQL withing SQL Server 2005. He also points out where there are differences from 2000 and supplies 2000 only solutions to a lot of the problems, which can help those that need to maintain two code bases. He regularly uses and addresses 2005 functionality so there is zero indications of this being a 2000 book warmed over for re-publication.

Make no mistakes here.
Read more ›
Comment 48 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
As someone quite familiar with Itzik Ben-Gan's work, I expected this to be a really good book. But since I've been reading about and working with SQL Server 2005 since early betas, I didn't expect to learn much. I was, as it turned out, wrong on both counts.

This book surpassed all of my expectations. It's more than just a really good book -- it's a great book -- and I learned quite a bit from reading it. Itzik and his co-authors have a knack for explaining every idea, down to the minute details that you might miss in other books or documentation. The examples are clear and precise, and the author team has done a great job of making even complex topics crystal clear.

This is certainly not a book for beginners; intermediate and advanced practitioners will want to use this book to help get more out of SQL Server. Learn the basics of T-SQL and SQL Server before tackling this one if you want to take full advantage of what it has to offer.
Comment 22 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
I strongly recommend this book to anyone wanting a better understanding of SQL server 2005. I have read several books in this series, they are all good, but this is the best by far. It starts by discussing the logical processing of query, which is very important for understand how to write effective queries. It then discusses how to evaluate your queries, it discusses indexes in extensive detail - to the point that you will understand how to they work and how to make effective indexes. It explains many of the new T-SQL features, and how to use them in real life scenarios. However, note that this is not a T-SQL reference guide. Books online serves that purpose. This is a MUST HAVE for my team.
Comment 11 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
The MS SQL books have dramatically risen in quality in a few short years. When SQL 7 and 2000 were released, there were may be 1-3 book which were truly outstanding. For SQL 2005, however, there are at least 5-10 books which are truly worthwhile and this is one of them.

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.
Comment 12 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
Real quick:

1. Target reader: someone with a good grasp of the 2000 Server wishing to learn the new stuff that came with the 2005 server (there's a lot: the 2005 product is _much_ better than the previous). This is probably the only thing that's unequivocally good about this book.

2. Content: Mostly about tables (joins, logical operations, physical operations, aggregates, a bit of esoterica -- puzzles, hierarchies, stuff like that, just a bit at the end). No CLR to speak of in this volume (there's a tiny bit in the secton on user-defined aggregates; much more of it in the other volume, Programming). This book _should_ be considered the first volume of the two-volume set. If you get this one, you'll get the other one too; neither tome is self-sufficient; in fact there's a lot of explicit interdependence.

3. Very clean technically: technical editing very good (no typos either).

4. Depth vs breadth: the book is more extensive than deep. Some people here say it's difficult -- and it is true, which unfortunately brings me to the next point:

5. Writing: ABHORRENT. That's why it seems difficult -- and it very much is, except it's not due to any kind of inherent difficulty of the subject matter. It's the authors' complete, laughable inability to use the English language to explain things that makes reading this book such a chore. There is also conceptual muddle (people write as they think).

Now, experience taught me to forgive literary incapacity to a _technical_ author (to a degree; and I do take notice and, if possible, avoid him in the future). In cases like that I put the blame squarely on the publisher, especially if otherwise I know the publisher to be solid.
Read more ›
Comment 20 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Recent Customer Reviews