- Debunking a persistent SQL Server myth about
- 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.
99 Why use both TRUNCATE and DROP? nov 8 '11
34 Is table aliasing a bad practice? sep 20 '11
33 Writing a simple bank schema: How should I keep my balances in sync with their transaction history? sep 10 '11
29 When should I rebuild indexes? aug 3 '11
28 Is nested view a good database design? sep 7 '11