Inside Microsoft SQL Server 2008: T-SQL Querying

Chapter 01: Logical Query Processing
Chapter 02: Set Theory and Predicate Logic
Chapter 03: Relational Model
Chapter 04: Query Tuning
Chapter 05: Complexity and Algorithms
Chapter 06: Subqueries, Table Expressions and Ranking Functions
Chapter 07: Joins and Set Operations
Chapter 08: Aggregating and Pivoting Data
Chapter 09: TOP and APPLY
Chapter 10: Data Modification
Chapter 11: Querying Partitioned Tables
Chapter 12: Graphs, Trees, Hierarchies and Recursive Queries
Appendix A: Logic Puzzles

Inside Microsoft SQL Server 2008: T-SQL Programming

Chapter 01: Views
Chapter 02: User Defined Functions
Chapter 03: Stored Procedures
Chapter 04: Triggers
Chapter 05: Transactions and Concurrency
Chapter 06: Error Handling
Chapter 07: Temporary Tables and Table Variables
Chapter 08: Cursors
Chapter 09: Dynamic SQL
Chapter 10: Working with Date and Time
Chapter 11: CLR User Defined Types
Chapter 12: Temporal Support in the Relational Model
Chapter 13: XML and XQuery
Chapter 14: Spatial Data
Chapter 15: Tracking Access and Changes to Data
Chapter 16: Service Broker
Appendix A - Companion to CLR Routines

Back to Inside T-SQL 2008 Main Page