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.