Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning)

Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning)
by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka

Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning)
List Price: $44.99
Our Price: $13.96
You Save: $31.03 (69%)
Availability: Usually ships in 1-2 business days
Buy Used: from $6.33 (click here)
Category: Book
See more book details and other editions


(Click here)
Buy this book at online book store in your country
Canada | UK | Germany | France

Book Summary Information

Author: Dejan Sarka, Itzik Ben-Gan, Lubor Kollar
Edition: Paperback
Audio: English (Unknown); English (Original Language); English (Published)
Published: 2006-04-26
ISBN: 0735623139
Number of pages: 632
Publisher: Microsoft Press

Book Reviews of Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning)

Book Review: Must Have
Summary: 5 Stars

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. This is a high-end book. If you're just getting started in T-SQL, you may want to start out somewhere else. If, after getting down the concepts of SELECT.. FROM... WHERE... GROUP BY... ORDER BY, etc., then come back here and learn what happens and the right reasons to do the right things with the scripts that you write.

I work primarily as a database developer, doing database design from logical models and business requirements and then developing stored procedures, etc., for accessing data from those databases. This kind of information is absolutely vital to doing the best job I can. I think I was predisposed to like this work, but I've actually been picking it up during the day to refer back to points that were unclear to me or that I want to better communicate to others, especially from the first two chapters.

Summary of Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning)

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. 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 processing
  • Apply a methodology to optimize query tuning
  • Solve relational division problems
  • Use CTEs and ranking functions to simplify and optimize solutions
  • Aggregate data with various techniques, including tiebreakers, pivoting, histograms, and grouping factors
  • Use the TOP option in a query to modify data
  • Query specialized data structures with recursive logic, materialized path, or nested sets solutions
  • PLUS?Improve your logic and get to the heart of querying problems with logic puzzles

Get code and database samples on the Web

Databases Books

Book Subjects
Most talked about in Databases Books
Mining for Gold on The Internet: How to Find Investment and Financial Information on the Internet ImageMining for Gold on The Internet: How to Find Investment and Financial Information on the Internet
by Mary Ellen Bates
McGraw-Hill Companies; Published: 2000-05-30; Paperback; Book
Best price: $20.47
Price in other shops: $26.95
Building XML Applications ImageBuilding XML Applications
by Simon St.; Cerami, Ethan Laurent
McGraw-Hill Companies; Published: 1999; Paperback; Book
Introduction to Data Communications and Local Area Networking Technology ImageIntroduction to Data Communications and Local Area Networking Technology
by Eduardo da Silva
HarperCollins Publishers Ltd; Published: 1986-08-28; Paperback; Book
Data Analysis Using SQL and Excel ImageData Analysis Using SQL and Excel
by Gordon S. Linoff
Wiley; Published: 2007-10-01; Paperback; Book
Best price: $27.16
Price in other shops: $45.00
Fundamentals of Database Systems (5th Edition) ImageFundamentals of Database Systems (5th Edition)
by Ramez Elmasri, Shamkant B. Navathe
Addison Wesley; Published: 2006-03-17; Hardcover; Book
Best price: $66.00
Price in other shops: $138.00
An Introduction to Database Systems (8th Edition) ImageAn Introduction to Database Systems (8th Edition)
by C.J. Date
Addison Wesley; Published: 2003-08-01; Paperback; Book
Best price: $99.93
Price in other shops: $169.00
Pragmatic ADO.NET: Data Access for the Internet World ImagePragmatic ADO.NET: Data Access for the Internet World
by Shawn Wildermuth
Addison-Wesley Professional; Published: 2002-11-15; Paperback; Book
Best price: $5.20
Price in other shops: $54.99
SQL Queries for Mere Mortals(R): A Hands-On Guide to Data Manipulation in SQL ImageSQL Queries for Mere Mortals(R): A Hands-On Guide to Data Manipulation in SQL
by Michael J. Hernandez, John L. Viescas
Addison-Wesley Professional; Published: 2000-08-31; Paperback; Book
Best price: $45.00
Price in other shops: $59.99
Microsoft Office Access 2003 QuickSteps ImageMicrosoft Office Access 2003 QuickSteps
by John Cronan, Virginia Anderson, Brenda Bryant Anderson
McGraw-Hill Osborne Media; Published: 2004-03-01; Paperback; Book
Best price: $2.70
Price in other shops: $19.99
Database Systems Concepts ImageDatabase Systems Concepts
by Henry F. Korth, Abraham Silberschatz, S. Sudarshan
Osborne/McGraw-Hill,U.S.; Published: 2001-08; Hardcover; Book
Similar Books and other products
Professional SQL Server 2005 Integration Services (Programmer to Programmer) ImageProfessional SQL Server 2005 Integration Services (Programmer to Programmer)
by Brian Knight, Allan Mitchell, Darren Green, Douglas Hinson, Kathi Kellenberger, Andy Leonard, Erik Veerman, Jason Gerard, Haidong Ji, Mike Murphy
Wrox; Published: 2006-01-31; Paperback; Book
Best price: $7.49
Price in other shops: $49.99
Programming Microsoft  SQL Server 2005 ImageProgramming Microsoft SQL Server 2005
by Andrew J Brust, Stephen Forte
Microsoft Press; Published: 2006-06-28; Paperback; Book
Best price: $5.99
Price in other shops: $49.99
Microsoft SQL Server 2005 Reporting Services ImageMicrosoft SQL Server 2005 Reporting Services
by Brian Larson
McGraw-Hill Osborne Media; Published: 2005-12-12; Paperback; Book
Best price: $22.34
Price in other shops: $49.99
Microsoft® SQL Server(TM) 2005 Reporting Services Step by Step (Step by Step (Microsoft)) ImageMicrosoft® SQL Server(TM) 2005 Reporting Services Step by Step (Step by Step (Microsoft))
by Stacia Misner, Hitachi Consulting
Microsoft Press; Published: 2006-05-24; Paperback; Book
Best price: $5.25
Price in other shops: $44.99
The Guru's Guide to Transact-SQL ImageThe Guru's Guide to Transact-SQL
by Ken Henderson
Addison-Wesley Professional; Published: 2000-03-04; Paperback; Book
Best price: $27.99
Price in other shops: $64.99
Inside Microsoft® SQL Server(TM) 2005: Query Tuning and Optimization ImageInside Microsoft® SQL Server(TM) 2005: Query Tuning and Optimization
by Kalen Delaney, Sunil Agarwal, Craig Freedman, Ron Talmage, Adam Machanic
Microsoft Press; Published: 2007-09-26; Paperback; Book
Best price: $9.83
Price in other shops: $49.99
Inside Microsoft SQL Server 2005: The Storage Engine (Solid Quality Learning) ImageInside Microsoft SQL Server 2005: The Storage Engine (Solid Quality Learning)
by Kalen Delaney
Microsoft Press; Published: 2006-10-18; Paperback; Book
Best price: $7.15
Price in other shops: $49.99
Beginning SQL Server 2005 Programming (Programmer to Programmer) ImageBeginning SQL Server 2005 Programming (Programmer to Programmer)
by Robert Vieira
Wrox; Published: 2006-02-27; Paperback; Book
Best price: $3.39
Price in other shops: $39.99
Inside Microsoft SQL Server 2005: T-SQL Programming (Solid Quality Learning) ImageInside Microsoft SQL Server 2005: T-SQL Programming (Solid Quality Learning)
by Itzik Ben-gan, Dejan Sarka, Roger Wolter
Microsoft Press; Published: 2006-06-14; Paperback; Book
Best price: $10.44
Price in other shops: $44.99
Microsoft SQL Server 2005 Unleashed ImageMicrosoft SQL Server 2005 Unleashed
by Ray Rankins, Paul Bertucci, Chris Gallelli, Alex T. Silverstein
Sams; Published: 2006-12-31; Paperback; Book
Best price: $34.99
Price in other shops: $64.99
Book store. Illustrated catalog of books on different categories