Inside Microsoft SQL Server 2008 : T-SQL querying

• Main Author: Ben-Gan, Itzik (Author)
• Format: Book
• Language: English
• Published: Redmond, Wash. : Microsoft Press, c2009
• Subjects: Microsoft SQL Server 2008 (databázový systém); Transact SQL (dotazovací jazyk); dotazovací jazyky; architektura klient/server; relační databáze; Microsoft SQL Server 2008; Transact SQL; query languages; client/server computing; relational databases; příručky; handbooks, manuals, etc
• ISBN: 9780735626034
• Physical Description: xxiv, 798 s. : il. ; 23 cm

Table of Contents:

• Chapter 1: Logical Query Processing
• Chapter 2: Set Theory and Predicate Logic
• Chapter 3: The Relational Model
• Chapter 4: Query Tuning
• Chapter 5: Algorithms and Complexity
• Chapter 6: Subqueries, Table Expressions and Ranking Functions
• Chapter 7: Joins and Set Operations
• Chapter 8: Aggregating and Pivoting Data
• Chapter 9: TOP and APPLY
• Chapter 10: Data Modification
• Chapter 11: Querying Partitioned Tables
• Chapter 12: Graphs, Trees, Hierarchies and Recursive Queries
• Appendix A: Logic Puzzles