logo
episode-header-image
May 2024
1h 4m

Erik Darling and Kendra Little Rate SQL ...

Kendra Little
About this episode

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 estimator, Table Variables, Automatic Plan Correction, Batch Mode, index rebuilds, Hekaton, NOLOCK, page compression, partitioning, filtered indexes, columnstore, join hints, PSPO, indexed hints, indexed views, optimize for unknown, RCSI, adding more memory, restarting the damn thing, scalar UDFs, and Persisted Memory Grant Feedback.

Up next
Jan 2024
Power BI Performance Tuning with Eugene Meidinger
Eugene Meidinger stops by to chat about Power BI Performance Tuning with Kendra. We talk about the various engines and languages used in Power BI and big-picture strategies for getting performance from the start. Eugene then talks about the community of tools and techniques that ... Show More
53m 54s
Sep 2023
Automated Deployments and the Art of the Database with Database Michael J Swart
<p>In this episode, Michael J Swart joins the Dear SQL DBA podcast to talk about databases, automation, and how he's come to illustrate some of the coolest blog posts ever to be written about data.</p> <p>Check out Michael's art and blog posts at <a href= "https://michaeljswart.c ... Show More
1h 5m
Sep 2023
Jer and Kendar Explore Optimized Locking
<p>SQL Server has a new feature that's currently only available in Azure SQL Database: Optimized Locking. <a href= "https://www.facility9.com/">Jeremiah Peschka</a> joins the podcast to talk through <a href= "https://learn.microsoft.com/sql/relational-databases/performance/optimi ... Show More
28m 57s
Recommended Episodes
Oct 2021
when indexes are useless | The Backend Engineering Show
<p>head to https://database.husseinnasser.com to get a discount coupon for my Introduction to Database Engineering course</p> <p>In this episode of the backend engineering show, I’ll discuss three instances where indexes can be useless and might add overhead to your operations. L ... Show More
27m 12s
Feb 2024
Episode 160 - OPTION RECOMPILE and the magical Turbo button
Guy tries to convince Eitan that OPTION(RECOMPILE) is the ultimate "Turbo" button in SQL Server, and that it's strongly underappreciated. Relevant links for more info: OPTION(RECOMPILE) (Transact-SQL) - SQL Server | Microsoft Learn Recompile a Stored Procedure - SQL Server | Micr ... Show More
32m 49s
Apr 2021
My Python CRUD App hits 2 million rows, Should I Shard my Database?
Hey Hussein I have a 2 million row table used in my CRUD python app, I’m worried that as the table grow my inserts will slow down, should I consider sharding my database or partition the table? thank you I’m avid of simplicity in design if I can do it in one machine I’ll do it. S ... Show More
21m 16s
Aug 2021
Table Clustering (Clustered Index) - The pros and cons
In this episode of the backend engineering show, I discuss database clustering. This is also known as table clustering, clustered index or Index organized table all names represents the same thing. I will talk about the benefits of clustering and also the disadvantages of impleme ... Show More
28m 33s
Mar 2020
Episode 114 - Lots of catching up to do
Guy Glantser is co-hosting with Eitan Blumin for the first time, and we have a lot of topics to cover and catching up to do. PASS and SQLBits Conferences Storage Best Practices for SQL on IaaS in Azure SQL VM RP (Resource Provider) Guy's hopes for SQL Server setup options SQL Ser ... Show More
38 m
Jun 2022
Sorting in Postgres 15 is 371% faster in certain cases
<p>Fantastic gains in Postgres 15! improved sorting by 371%. Normally you can avoid sorting by using an index access path. However, you can’t always have an index on every group by, order by, join or distinct predict. This will come handy. Let us discuss</p> <p>Resources</p> <p>< ... Show More
9m 37s
Aug 2021
Partial Indexing | Backend Engineering Show
While the benefits of partial indexes can have a great impact on your database system performance, the implications are also great if misused. Let us discuss partial indexing (Also known as filtered indexes in SQL Server) Become a Member on YouTube https://www.youtube.com/channel ... Show More
18m 39s
Jan 2022
Index page splits | The Backend Engineering Show
In this episode of the backend engineering show I discuss the ramification of index page splits which results in fragmented index yielding slow query performance when using indexes. I go through what a page is, how a page is read and written in the database and finally discuss th ... Show More
31m 54s
Apr 2016
Show 44 - SSMS Can Beep
Did you know SSMS can make sounds? We start the show with some interesting things you might do with it. In addition, we talk about: SQL Server on Linux Hadoop fundamentals SQL Server 2016 eBook Changes to auto update statistics in SQL Server 2016 New SQL Server 2016 database leve ... Show More
37m 3s
May 2022
Why this query is fast
<p>Welcome to another database question. In this question I created a community poll question and provided some answers. All answers can be correct of course but the question is what is the most efficient? this is what I try to explore in this video and compare how different data ... Show More
17m 50s
Listen to millions of songs and podcasts on Anghami