- 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: #290,742 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
Discover what to read next through the Amazon Book Review. Learn more.
Frequently Bought Together
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.
Top Customer Reviews
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 ›
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.
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.
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 ›
Most Recent Customer Reviews
Despite a little overwhelming for me, it is definitely worth a read.Published on July 10, 2014 by Hugo
I like this book,
it is well written and accurate, a lot of examples.
Probably I will buy another books of this author.
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... Read morePublished on March 30, 2010 by Rouben Gargaloyan
Very limited coverage. Nothing about date processing. I have better luck just doing a Google search on whatever it is I'm looking for.Published on February 6, 2010 by Softie Developer
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. Read more
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. Read morePublished on May 20, 2009 by Paul A. Hernandez
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. Read morePublished on May 20, 2008 by Joshua Huber
Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning)
This is a great reference or review text. Read more
This is the 2nd book of the 4 part "Inside-SQL" series, with each book I imagine, appealing to a different reader. Read morePublished on October 8, 2007 by Matthew Bryde