Episode 159 - Select * Wastes Money

Episode 159 - Select * Wastes Money

Up next

Episode 188 - Virtualization pitfalls and best practices with SQL Server

Guy talks about an interesting incident involving performance problems in a virtual environment. And also, we talk about the SSMS StatisticsParser extension and the question of SSMS extensions in general. Relevant links: vmware.com/docs/sql-server-on-vmware-best-practices-guide H ...  Show more

Episode 187 - Transactional Replication Between Availability Groups

Guy and Eitan discuss a few new things in the latest SSMS update, and Eitan tells about a very peculiar use case involving transactional replication and AlwaysOn Availability Groups, and Guy talks about a use case involving deletion triggers. Important note: The part about SQL Se ...  Show more

Recommended Episodes

164: Choosing a Database For Your Project With Kris Zyp
Programming Throwdown

Things to consider when choosing a database Speed & Latency Consistency, ACID Compliance Scalability Language support & Developer Experience Relational vs. NoSQL) Data types Security Database environment Client vs Server access Info on Kris & Harper: Website: harperdb.io Twitter: ...  Show more

Can NULLs Improve your Database Queries Performance? - The Backend Engineering Show
The Backend Engineering Show with Hussein Nasser

In this episode, we will discuss NULLs in database systems. I’ll go through the following:

What is Null?

NULLs persistence

<ul> <li>Whether you store a 0 or 2 billion value in the field 32bit integer field it costs 32 bit</li> <li>when you store a NULL in 3 ...  Show more

Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques
Dear SQL DBA

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

Training Resources for SQL Noobs
Dear SQL DBA

New to learning SQL Server? Get the scoop on free online resources to look up information, ask questions of community members, and learn SQL Server from the ground up. Links from the episode are at:  https://sqlworkbooks.com/dear-sql-dba/training-resources-for-sql-noobs/