Pergi ke luar talian dengan aplikasi Player FM !
Episode 159 - Select * Wastes Money
Manage episode 393988252 series 48799
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! πππ₯
260 episod
Manage episode 393988252 series 48799
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! πππ₯
260 episod
Semua episod
ΓSelamat datang ke Player FM
Player FM mengimbas laman-laman web bagi podcast berkualiti tinggi untuk anda nikmati sekarang. Ia merupakan aplikasi podcast terbaik dan berfungsi untuk Android, iPhone, dan web. Daftar untuk melaraskan langganan merentasi peranti.