Are Bad Statistics Making My Query Slow?

Dear SQL DBA

Player FM - Internet Radio Done Right

22 subscribers

اضافه شده در seven سال پیش

محتوای ارائه شده توسط Kendra Little. تمام محتوای پادکست شامل قسمت‌ها، گرافیک‌ها و توضیحات پادکست مستقیماً توسط Kendra Little یا شریک پلتفرم پادکست آن‌ها آپلود و ارائه می‌شوند. اگر فکر می‌کنید شخصی بدون اجازه شما از اثر دارای حق نسخه‌برداری شما استفاده می‌کند، می‌توانید روندی که در اینجا شرح داده شده است را دنبال کنید.https://fa.player.fm/legal

Squid Game: The Official Podcast

1
Keys and Knives - S3 Ep 1 26:28

۷ روز پیش26:28

پخش در آینده

لیست ها

پسندیدن

دوست داشته شد

26:28

Squid Game is back—and this time, the knives are out. In the thrilling Season 3 premiere, Player 456 is spiraling and a brutal round of hide-and-seek forces players to kill or be killed. Hosts Phil Yu and Kiera Please break down Gi-hun’s descent into vengeance, Guard 011’s daring betrayal of the Game, and the shocking moment players are forced to choose between murdering their friends… or dying. Then, Carlos Juico and Gavin Ruta from the Jumpers Jump podcast join us to unpack their wild theories for the season. Plus, Phil and Kiera face off in a high-stakes round of “Hot Sweet Potato.” SPOILER ALERT! Make sure you watch Squid Game Season 3 Episode 1 before listening on. Play one last time. IG - @SquidGameNetflix X (f.k.a. Twitter) - @SquidGame Check out more from Phil Yu @angryasianman , Kiera Please @kieraplease and the Jumpers Jump podcast Listen to more from Netflix Podcasts . Squid Game: The Official Podcast is produced by Netflix and The Mash-Up Americans.…

۸ سال پیش 35:02

MP3•خانه قسمت

An important query is suddenly slow. Is it because statistics are out of date? This is tricky to figure out, and updating statistics right away can make troubleshooting even harder. Learn how to use query execution plans to get to the heart of the question and find out if stats are really your problem, or if it's something else. In this 35 minute episode:

00:39 SQL Server 2017 Announced 01:10 New video from Microsoft's Joe Sack demonstrating Adaptive Query Processing 03:05 This week's question: Are bad stats making my query slow? 05:26 Demo of finding plan in cache and analyzing stats begins 28:17 What to do when stats ARE the problem

Code samples: https://gist.github.com/LitKnd/f07848d59cedc61fd057d12ab966f703

Links from the episode:

SQL Server 2017 Adaptive Query Processing video by Joe Sack: https://www.youtube.com/watch?v=szTmo6rTUjM&feature=youtu.be

Michael J Swart on finding Dark Matter Queries: http://michaeljswart.com/2017/04/finding-your-dark-queries/

Got a question for Dear SQL DBA? https://SQLWorkbooks.com/ask

82 قسمت

#Tech #Tech News #Sqlserver #Sqlworkbooks #News #Kendra Littles #DBA #Database