advanced-patterns
Installation
SKILL.md
Advanced T-SQL Patterns
Advanced techniques for complex SQL Server scenarios.
Quick Reference
Pattern Selection Guide
| Task | Pattern |
|---|---|
| Hierarchical data | Recursive CTE |
| Top N per group | ROW_NUMBER + CTE |
| Correlated subquery alternative | CROSS/OUTER APPLY |
| Upsert (insert or update) | MERGE |
| Capture modified rows | OUTPUT clause |
| Historical data tracking | Temporal tables |
| High-throughput OLTP | In-Memory OLTP |
| Multiple aggregation levels | ROLLUP/CUBE/GROUPING SETS |