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: 28178 Studio: Microsoft Press
Product DescriptionThis thorough, hands-on reference for database developers and administrators delivers expert guidance on sophisticated uses of Transact-SQL (T-SQL)—one of the most familiar and powerful programming languages for SQL Server. Written by a T-SQL guru, this guide focuses on advanced querying techniques and how queries are interpreted and processed by the SQL Server execution engine. You’ll get in-depth coverage of the sophisticated uses of T-SQL, including the differences between logical and physical processing, nesting of queries, and much more. The book explains and compares solutions to database-development problems in both SQL Server 2000 and SQL Server 2005, discussing the new T-SQL programming features added to SQL Server 2005 in detail. Includes extensive code samples, table examples, and logic puzzles to help database developers and administrators understand the intricacies and help promote mastery of T-SQL
What Others Say
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.
Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning) 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, Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning) goes FAR beyond that, and digs deep into real world examples that really shine a light on your work.
I purchased Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning) almost a year ago, and it's still one of the most referenced books I have. I am constantly pulling it out when I reach a problem in my work, and Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning) always has great pointers to a solution.
Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning) will make you a T-SQL junkie, get it.
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 engine.
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 Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning) 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, Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning) 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 Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning), 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 ... Read More
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 Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning), 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. Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning) is an another example of authors who ... Read More
Excellent
Normally I don't write a review but I liked Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning) 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. Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning) 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. Then it dives into the language. Each example is well thought. The example goes over the syntax, performance and also optimization. I read all of it and did most of the examples.
