- 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.
116 Should developers be able to query production databases? Jan 6 '12
106 Why use both TRUNCATE and DROP? Nov 8 '11
34 Writing a simple bank schema: How should I keep my balances in sync with their transaction history? Sep 10 '11
34 Is table aliasing a bad practice? Sep 20 '11
30 When should I rebuild indexes? Aug 3 '11
29 Is nested view a good database design? Sep 7 '11