- 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.
95 Why use both TRUNCATE and DROP? nov 8 '11
33 Is table aliasing a bad practice? sep 20 '11
31 Writing a simple bank schema: How should I keep my balances in sync with their transaction history? sep 10 '11
26 When should I rebuild indexes? aug 3 '11
26 Is nested view a good database design? sep 7 '11
18 Passing array parameters to a stored procedure oct 19 '11