Binding: Paperback Dewey Decimal Number: 005.7565 EAN: 9780735623132 ISBN: 0735623139 Label: Microsoft Press Manufacturer: Microsoft Press Number Of Items: 1 Number Of Pages: 632 Publication Date: April 26, 2006 Publisher: Microsoft Press Sales Rank: 12323 Studio: Microsoft Press
Product DescriptionA comprehensive, hands-on reference for database developers and administrators, this book focuses on advanced querying techniques using Transact-SQL (T-SQL), the database programming language built into SQL Server. Includes code and table examples.
Customer Reviews
Average Rating:
Rating: - Fantastic in every way
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 ... Read More
Rating: - Excellelent Intermediate or review
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 ... Read More
Rating: - An excellent contribution to the "Inside-SQL" series
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 ... Read More
Rating: - Pedantic
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.
Rating: - Excellent
Normally I don't write a review but I liked this book enough to do so. I am a programmer not an SQL developer. I knew the basics but not the details and I had to write complex queries in SQL 2005 so I researched books for couple days before I bought this one. I have never heard of CTE, APPLY, ROW_NUMBER or PIVOT to mention few. This book at the beginning gives you the basics to understand how queries are processed internally, the difference between the types of indexes and how to read the execution plans. ... Read More
- Fantastic in every way
- Excellelent Intermediate or review
