Programming Books C Java PHP Python Learn more Browse Programming Books
Qty:1
  • List Price: $44.99
  • Save: $11.03 (25%)
FREE Shipping on orders over $35.
Only 1 left in stock (more on the way).
Ships from and sold by Amazon.com.
Gift-wrap available.
Inside Microsoft SQL Serv... has been added to your Cart
FREE Shipping on orders over $35.
Used: Very Good | Details
Sold by Glorious Gifts
Condition: Used: Very Good
Comment: book and binding show very little wear
Access codes and supplements are not guaranteed with used items.
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Inside Microsoft SQL Server 2005: T-SQL Querying (Developer Reference) Paperback – April 26, 2006

ISBN-13: 978-0735623132 ISBN-10: 0735623139 Edition: 1st

Buy New
Price: $33.96
12 New from $6.00 50 Used from $0.01 1 Collectible from $9.98
Amazon Price New from Used from
Paperback, April 26, 2006
$33.96
$6.00 $0.01

There is a newer edition of this item:

Amazon%20Web%20Services


Frequently Bought Together

Inside Microsoft SQL Server 2005: T-SQL Querying (Developer Reference) + Inside Microsoft SQL Server 2005: T-SQL Programming (Developer Reference) + Inside Microsoft® SQL Server™ 2005: The Storage Engine (Developer Reference)
Price for all three: $105.66

Some of these items ship sooner than the others.

Buy the selected items together

NO_CONTENT_IN_FEATURE

Shop the New Digital Design Bookstore
Check out the Digital Design Bookstore, a new hub for photographers, art directors, illustrators, web developers, and other creative individuals to find highly rated and highly relevant career resources. Shop books on web development and graphic design, or check out blog posts by authors and thought-leaders in the design industry. Shop now

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: 9 x 7.5 x 1.6 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: #922,429 in Books (See Top 100 in Books)

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.


More About the Authors

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

I like this book, it is well written and accurate, a lot of examples.
Elvira Kushner
As someone quite familiar with Itzik Ben-Gan's work, I expected this to be a really good book.
Adam Machanic
Then again, this means that instead of reading the book once, you will have to read it twice.
Erland Sommarskog

Most Helpful Customer Reviews

48 of 51 people found the following review helpful By Grant Fritchey 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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
22 of 23 people found the following review helpful By Adam Machanic on November 25, 2006
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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
11 of 11 people found the following review helpful By Stephen on February 22, 2007
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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
12 of 13 people found the following review helpful By Jaewoo Kim VINE VOICE on September 20, 2007
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.

PROS:
1)Awesome details on Indexes and Query plans
2)Solid advice on how to improve T-SQL for better performance.

Cons:
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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
20 of 24 people found the following review helpful By Malleus Maleficarum on July 26, 2007
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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Recent Customer Reviews