Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning)
by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka
List Price:
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
Book Summary Information
Author: Dejan Sarka, Itzik Ben-Gan, Lubor KollarEdition: 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.
More Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning) reviews:
1 2 3 4 5 6 7
1 2 3 4 5 6 7
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
- Arts & Photography
- Biographies & Memoirs
- Business & Investing
- Children's Books
- Comics & Graphic Novels
- Computers & Internet
- Cooking, Food & Wine
- Entertainment
- Gay & Lesbian
- Health, Mind & Body
- History
- Home & Garden
- Horror
- Law
- Literature & Fiction
- Mystery & Thrillers
- Nonfiction
- Outdoors & Nature
- Parenting & Families
- Professional & Technical
- Reference
- Religion & Spirituality
- Romance
- Science
- Science Fiction & Fantasy
- Sports
- Teens
- Travel
Most talked about in Databases Books
Mining for Gold on The Internet: How to Find Investment and Financial Information on the Internetby Mary Ellen Bates
McGraw-Hill Companies; Published: 2000-05-30; Paperback; Book
Best price: $20.47
Price in other shops:
Building XML Applicationsby Simon St.; Cerami, Ethan Laurent
McGraw-Hill Companies; Published: 1999; Paperback; Book
Introduction to Data Communications and Local Area Networking Technologyby Eduardo da Silva
HarperCollins Publishers Ltd; Published: 1986-08-28; Paperback; Book
Data Analysis Using SQL and Excelby Gordon S. Linoff
Wiley; Published: 2007-10-01; Paperback; Book
Best price: $27.16
Price in other shops:
Fundamentals 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:
An 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:
Pragmatic ADO.NET: Data Access for the Internet Worldby Shawn Wildermuth
Addison-Wesley Professional; Published: 2002-11-15; Paperback; Book
Best price: $5.20
Price in other shops:
SQL Queries for Mere Mortals(R): A Hands-On Guide to Data Manipulation in SQLby Michael J. Hernandez, John L. Viescas
Addison-Wesley Professional; Published: 2000-08-31; Paperback; Book
Best price: $45.00
Price in other shops:
Microsoft Office Access 2003 QuickStepsby 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:
Database Systems Conceptsby 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)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:
Programming Microsoft SQL Server 2005by Andrew J Brust, Stephen Forte
Microsoft Press; Published: 2006-06-28; Paperback; Book
Best price: $5.99
Price in other shops:
Microsoft SQL Server 2005 Reporting Servicesby Brian Larson
McGraw-Hill Osborne Media; Published: 2005-12-12; Paperback; Book
Best price: $22.34
Price in other shops:
Microsoft® 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:
The Guru's Guide to Transact-SQLby Ken Henderson
Addison-Wesley Professional; Published: 2000-03-04; Paperback; Book
Best price: $27.99
Price in other shops:
Inside Microsoft® SQL Server(TM) 2005: Query Tuning and Optimizationby 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:
Inside 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:
Beginning 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:
Inside 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:
Microsoft SQL Server 2005 Unleashedby Ray Rankins, Paul Bertucci, Chris Gallelli, Alex T. Silverstein
Sams; Published: 2006-12-31; Paperback; Book
Best price: $34.99
Price in other shops: