Inside Microsoft SQL Server 2005: T-SQL Querying (Developer Reference)
| Author | : | |
| Rating | : | 4.35 (536 Votes) |
| Asin | : | 0735623139 |
| Format Type | : | paperback |
| Number of Pages | : | 640 Pages |
| Publish Date | : | 2013-08-04 |
| Language | : | English |
DESCRIPTION:
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
Database developers and administrators get best practices, sample databases, and code to master the intricacies of the programming language—solving complex problems with real-world solutions.Discover how to:Understand logical and physical query processingApply a methodology to optimize query tuningSolve relational division problemsUse CTEs and ranking functions to simplify and optimize solutionsAggregate data with various techniques, including tiebreakers, pivoting, histograms, and grouping factorsUse the TOP option in a query to modify dataQuery specialized data structures with recursive logic, materialized path, or nested sets solutionsPLUS—Improve your logic and get to the heart of querying problems with logic puzzlesGet code and database samples on the Web. Take a detailed look at the internal architecture of T-SQL—and unveil the power of set-based querying—with comprehensive reference and advice from the experts
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.. Dejan Sarka is a mentor with SolidQ and focuses on development of database and business intelligence appli
"Must Have" according to Grant Fritchey. 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 th. An excellent contribution to the "Inside-SQL" series This is the 2nd book of the An excellent contribution to the "Inside-SQL" series Matthew Bryde 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 the read. 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 the read. "Learning from the Greats" according to David R. Steele. I found the book "Inside Microsoft SQL Server 2005: T-SQL Querying" a very good guide to the in's and out's of SQL querying from the standpoint of a student, but, the way the book is written, it does not "low-brow" anyone more experienced. It is just the sort of book that would appeal and enlighten anyone who is willing to put the print to work and develop bona fide, time-tested expertise in querying Microsoft SQL Server 2005. In other words, it is an investment in knowledge that pays big dividen