文档介绍：Inside Microsoft® SQL Server™ 2005 T-SQL Querying
By Itzik Ben-Gan - (Solid Quality Learning), Lubor Kollar, Dejan Sarka
...............................................
Publisher: Microsoft Press
Pub Date: March 07, 2006
Print ISBN-10: 0-7356-2313-9
Print ISBN-13: 978-0-7356-2313-2
Pages: 640
Table of Contents | Index
prehensive, 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.
Inside Microsoft® SQL Server™ 2005 T-SQL Querying
By Itzik Ben-Gan - (Solid Quality Learning), Lubor Kollar, Dejan Sarka
...............................................
Publisher: Microsoft Press
Pub Date: March 07, 2006
Print ISBN-10: 0-7356-2313-9
Print ISBN-13: 978-0-7356-2313-2
Pages: 640
Table of Contents | Index
Copyright
Foreword
Preface
Acknowledgments
Introduction
Chapter 1. Logical Query Processing
Logical Query Processing Phases
Sample Query Based on Customers/Orders Scenario
Logical Query Processing Phase Details
New Logical Processing Phases in SQL Server 2005
Conclusion
Chapter 2. Physical Query Processing
Flow of Data During Query Processing
Compilation
Conclusion
Chapter 3. Query Tuning
Sample Data for This Chapter
Tuning Methodology
Tools for Query Tuning
Index Tuning
Preparing Sample Data
An Examination of Set-Based vs. Iterative/Procedural Approaches, and a Tuning Exercise
Additional Resources
Conclusion
Chapter 4. Subqueries, Table Expressions, and Ranking Functions
Subqueries
Table Expressions
Analytical Ranking Functions
Auxiliary Table of Numbers
Existing and Missing Ranges (Also Known as Islands and Gaps)
Conclusion
Chapter 5. Joins and Set Operations
Joins
Set Operations
Conclusion
Chapter 6. Aggregating and Pivoting Data
OVER Clause
Tiebreakers
Running Aggregations
Pivot