Episode 159 - Select * Wastes Money
- Author
- SQL Server Radio
- Published
- Mon 08 Jan 2024
- Episode Link
- http://sqlserverradio.com/episode-159-select-wastes-money
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! 🎉🎈🥂
