SQL Server Radio

Episode 159 - Select * Wastes Money


Listen Later

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! 🎉🎈🥂

...more
View all episodesView all episodes
Download on the App Store

SQL Server RadioBy Guy Glantser, Eitan Blumin

  • 4.6
  • 4.6
  • 4.6
  • 4.6
  • 4.6

4.6

20 ratings


More shows like SQL Server Radio

View all
Fareed Zakaria GPS by CNN Podcasts

Fareed Zakaria GPS

3,392 Listeners

Voice of the DBA by Steve Jones

Voice of the DBA

9 Listeners

Top Traders Unplugged by Niels Kaastrup-Larsen

Top Traders Unplugged

594 Listeners

Software Engineering Radio by se-radio@computer.org

Software Engineering Radio

272 Listeners

The Cloudcast by Massive Studios

The Cloudcast

155 Listeners

SQL Data Partners Podcast by Carlos L Chacon

SQL Data Partners Podcast

27 Listeners

Science Vs by Spotify Studios

Science Vs

12,193 Listeners

Dear SQL DBA by Kendra Little

Dear SQL DBA

28 Listeners

Data Engineering Podcast by Tobias Macey

Data Engineering Podcast

145 Listeners

The Indicator from Planet Money by NPR

The Indicator from Planet Money

9,523 Listeners

.NET Rocks! by Carl Franklin and Richard Campbell

.NET Rocks!

244 Listeners

The Stack Overflow Podcast by The Stack Overflow Podcast

The Stack Overflow Podcast

62 Listeners

All-In with Chamath, Jason, Sacks  Friedberg by All-In Podcast, LLC

All-In with Chamath, Jason, Sacks Friedberg

9,830 Listeners

Hard Fork by The New York Times

Hard Fork

5,469 Listeners

Prof G Markets by Vox Media Podcast Network

Prof G Markets

1,329 Listeners