Ben-Gan I. - Inside Microsoft SQL Server 2005 T-SQL Querying [2006, CHM, ENG]

Книги и журналы » Компьютерная литература » Программы от Microsoft

Inside Microsoft SQL Server 2005 T-SQL Querying

Год: 2006
Автор: Ben-Gan I.
Жанр: Учебное пособие
Издательство: Microsoft Press
ISBN: 0-7356-2313-9, 978-0-7356-2313-2
Язык: Английский
Формат: CHM
Качество: Изначально компьютерное (eBook)
Количество страниц: 640

Описание: A comprehensive, 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.
[spoiler="Примеры страниц"]

[/spoiler]
[spoiler="Оглавление"]
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
Pivoting
Unpivoting
Custom Aggregations
Histograms
Grouping Factor
CUBE and ROLLUP
Conclusion
Chapter 7. TOP and APPLY
SELECT TOP
APPLY
Solutions to Common Problems Using TOP and APPLY
Conclusion
Chapter 8. Data Modification
Inserting Data
Deleting Data
Updating Data
Other Performance Considerations
Conclusion
Chapter 9. Graphs, Trees, Hierarchies, and Recursive Queries
Terminology
Scenarios
Iteration/Recursion
Materialized Path
Nested Sets
Transitive Closure
Conclusion
Appendix A. Logic Puzzles
Puzzles
Puzzle Solutions
Conclusion
About the Contributors
Index
[/spoiler]
Опубликовано группой