Go offline with the Player FM app!
Episode 159 - Select * Wastes Money
Manage episode 393997327 series 3505255
Guy and Eitan discuss various practices in SQL Server that hurt performance and possibly waste money, negative VarDecimal numbers, renumbering Identity columns, and the new Azure Database Fleet Manager.
Relevant links:
- SQL Server IN Clause With Multiple Literal Values Performance Behaviour | Neeraj Prasad Sharma
- Could SQL Injection be dangerous even when perfectly safe? | Eitan Blumin
- The Anatomy of Vardecimals | Mark S. Rasmussen
- Utility Scripts/ReNumber_Identity_Column.sql
- Introducing Azure Database Fleet Manager
Also, Happy New Year! πππ₯
164 episodes
Manage episode 393997327 series 3505255
Guy and Eitan discuss various practices in SQL Server that hurt performance and possibly waste money, negative VarDecimal numbers, renumbering Identity columns, and the new Azure Database Fleet Manager.
Relevant links:
- SQL Server IN Clause With Multiple Literal Values Performance Behaviour | Neeraj Prasad Sharma
- Could SQL Injection be dangerous even when perfectly safe? | Eitan Blumin
- The Anatomy of Vardecimals | Mark S. Rasmussen
- Utility Scripts/ReNumber_Identity_Column.sql
- Introducing Azure Database Fleet Manager
Also, Happy New Year! πππ₯
164 episodes
All episodes
×Welcome to Player FM!
Player FM is scanning the web for high-quality podcasts for you to enjoy right now. It's the best podcast app and works on Android, iPhone, and the web. Signup to sync subscriptions across devices.