Intervals
- Interval Queries in SQL Server
- Academic Paper – Managing Intervals Efficiently in Object-Relational Databases
- A Static Relational Interval Tree by Laurent Martin:
T-SQL
- T-SQL Fundamentals Fourth Edition (MSPress, Coming Soon; Q1 2023)
- T-SQL Fundamentals Third Edition (MSPress, 2016)
- T-SQL Querying (MSPress, 2015)
- T-SQL Window Functions Second Edition (MSPress, 2019)
- Exam Ref 70-761 Querying Data with Transact-SQL (MSPress, 2017)
Set Theory
- Set Theory and Logic (Dover Publications) by Robert R Stoll
- Set Theory and Its Philosophy : A Critical Introduction (Oxford University Press) by Michael Potter
SQL and Relational Theory
- SQL and Relational Theory: How to Write Accurate SQL Code (O’Reilly, 2015) by C. J. Date
- Free SQL Server Developer edition
- SQL Server 2016 Wide World Importers sample database (see ER diagrams for schemas: Application, Sales, Purchasing, Warehouse)
- Adventure Works 2014 Sample Databases
- TSQLV6 Sample Database (see ER diagram)
- TSQLV5 Sample Database (see ER diagram)
- TSQLV4 Sample Database (see ER diagram)
- TSQLV3 Sample Database
- PerformanceV5 Sample Database
- PerformanceV3 Sample Database
- GetNums Function
- TSQL2012 Sample Database
- Performance Sample Database
Source Code for Recent Conferences:
- Hone Your T-SQL Querying Skills
- Beware of Nondeterministic T-SQL Code
- Advanced T-SQL Querying and Query Tuning
- Table Expressions
- Workarounds for T-SQL restrictions and limitations
- Performance-centric T-SQL
- Mastering T-SQL Querying Fundamentals
- Advanced T-SQL Querying and Query Tuning
- Workarounds for T-SQL Restrictions and Limitations
- T-SQL tips and tricks focusing on backdoors and workarounds
- Missing T-SQL querying features for handling NULLs and for data analysis
- Advanced T-SQL Querying and Query Tuning
- Itzik’s Articles in SQLPerformance.Com
- Itzik’s Articles in IT Pro Today
- Paul White’s Page Free Space blog
- Paul White @ SQLPerformance
- Erland Sommarskog’s home page
- Dmitry Pilugin’s Notes
- Erik Darling Data
- SQLPerformance.Com
- Craig Freedman’s SQL Server Blog
- Benjamin Nevarez
- Microsoft SQL Server Blog
- SQL CAT blog
- MSSQL Tiger Team Blog