Notable posts:
- Debunking a persistent SQL Server myth about
TRUNCATE
. - Debunking another SQL Server myth about variable declarations causing proc recompiles.
- Understanding how certain SQL Server functions dynamically cast their output.
- Using a recursive CTE to find the first ancestor in a hierarchy to satisfy certain conditions.