Are you worried that you talk too fast when you give a speech, talk, or presentation?
In this episode, I give you simple, practical tips that I’ve used to successfully improve the way I give presentations. Four years ago, I got frustrated feedback from listeners who had a hard time keeping up with my mouth; now I get congratulations that the pace was great.
A query is slow, and you figure out how to collect the query execution plan. Now what?
In this video, I talk “big picture” about what execution plans are, what “cost” is, why to collect “compiled for” values, and the steps I take to analyze execution plans while performance tuning queries.
To see this in action, you can play along with this sample script.
Table partitioning makes execution plans a bit more confusing.
I have a free online course which walks you through decoding execution plans, including whether or not partition elimination occurred.
Sharpen your performance tuning and indexing skills this summer, for free, one week at a time!
You’ve got a performance problem and you know just the cool index trick that will fix it!
Until it goes utterly wrong.
Join me for this free session in the 24 hours of PASS to see multiple quick demos of index changes that seem like a great idea… until they either don’t work, or make things worse.
My session is on Wed, July 19, 9 am Pacific / 12 pm Eastern / 4pm UTC.
SQL Server has more than one way to pull pages in from disk for your queries. SQL Server can do a physical read of an 8KB page, or an extent of 8 of those 8KB pages.
Copyright (c) 2025, Catalyze SQL, LLC; all rights reserved. Opinions expressed on this site are solely those of Kendra Little of Catalyze SQL, LLC. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.