Episode 159 - Select * Wastes Money

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

Guy and Eitan discuss news regarding SQL Server 2025, specifically that it's now publicly available on Amazon RDS, but also that Web Edition is now gone. Also, Guy shares an interesting use case with troubleshooting disk IO latency issues. And finally, Guy and Eitan discuss the d ... Show More

Guy and Eitan go over Paul Randal's article of "Top Ten SQL Server Performance Tuning Best Practices" (published in last March), and add their own input. We also talk about considerations of upgrading SQL Server to 2025, and we also learn something new about Temp Table Caching. R ... Show More

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

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