logo
episode-header-image
Jan 2024
37m 55s

Episode 159 - Select * Wastes Money

Guy Glantser, Eitan Blumin
About this episode

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:

Also, Happy New Year! 🎉🎈🥂

Up next
Nov 2
Episode 193 - Dedicated to Hugo Kornelis
This episode is dedicated to a dear friend of the SQL Server community - Hugo Kornelis. Hugo, this one is for you ❤️ Relevant links: Game over - SQLServerFast.com Meet Hugo Kornelis, Execution Plan Expert. - Brent Ozar Unlimited® 
21m 36s
Oct 12
Episode 192 - What is new at SQLCon 2026 Barcelona
Guy and Eitan are spiritually obligated to talk about Microsoft's announcements made at SQLCon/FabCon Europe 2026 that took place on September. UGH... FINE! Relevant links: What's new across Microsoft SQL at SQLCon/FabCon Europe 2026 - Azure SQL Dev Corner More performance and fl ... Show More
35m 4s
Sep 8
Episode 191 - High CPU in SQL Server 2025
Guy and Eitan discuss an interesting case study where crazy high CPU was detected after an upgrade to SQL Server 2025. Relevant links: SQL 2025 showing crazy-high CPU | LobsterPot Solutions Enable Automatic Tuning - Azure SQL Database & Azure SQL Managed Instance | Microsoft Lear ... Show More
29m 4s
Recommended Episodes
May 2024
Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques
Erik Darling joins Kendra Little to rate different SQL Server Performance Tuning Techniques in episode 81 of the Dear SQL DBA podcast. We share our opinions of... (deep breath)   Recompile hints, Query Store hints and plan forcing, CTEs, Resource Governor, the legacy cardinality ... Show More
1h 4m
Aug 2018
SLP6 - Fiat Money as 'fad diet', with Bitstein
In this episode with Bitstein, we break down Paul Krugman's errors in his NYT "Transaction Costs and Tethers: Why I’m a Crypto Skeptic" column, as well as other topics: Mischaracterisation of what money's purpose is Krugman's 'nirvana fallacies' in money Why fiat ... Show More
1h 5m