Videos

  1. Home
  2. Videos
  3. (Page 3)
Office Hours

[Video] Office Hours: Open Q&A About SQL Server

Videos
2 Comments
Office Hours Podcast For those of you who miss our old Office Hours webcasts and feel lonely during the quarantines, I’m doing my part to help with free weekend webcasts. For the next couple of Saturday & Sunday mornings from 6AM-8AM Pacific (iCal), you can catch me on my Twitch, YouTube, or Facebook channels. I’ll be: Live coding in the First…
Read More
Office Hours Podcast

Announcing Saturday & Sunday Office Hours.

Videos
3 Comments
During the quarantines, I’m doing free training. It looks like we’re going to be stuck inside here for another long while, so for the next couple of months, I’m bringing back Office Hours, but on a different schedule. Every Saturday & Sunday morning from 6AM-8AM Pacific (iCal), you can catch me on my Twitch, YouTube, or Facebook…
Read More

[Video] How to Find Queries Using OPTION RECOMPILE (And Their Parameters)

Development, Videos
1 Comment
For years, I hated troubleshooting servers with high CPU usage caused by queries constantly asking for new execution plans. Hated it. SQL Server just doesn’t make it easy to find queries with recompile hints. Then Erik Darling’s sp_HumanEvents came along. And now troubleshooting frequent compilations is as easy as this: Transact-SQL EXEC dbo.sp_HumanEvents @event_type =…
Read More

[Video] Watch Brent Write Queries

Videos
3 Comments
This morning, I wanted to write a few new “background noise” queries for my Mastering classes. In those classes, the students run live workloads against the Stack Overflow database and troubleshoot performance issues, and the more of a varied workload I’ve got running, the more realistic it feels. For this session, I specifically wanted to…
Read More

[Video] Watch Brent Write T-SQL

This morning I worked on a new check for sp_BlitzFirst to find statistics that were updated in the last 15 minutes, possibly causing plan caching issues and parameter sniffing. I streamed it live, and you can watch. In part 1, the first hour, I write the proof-of-concept query: In part 2, the second hour, I…
Read More

[Video] How Can I Measure If My Database Does More Reads Than Writes?

When someone asks you, “Is this database read-intensive or write-intensive?” you probably look at sys.dm_io_virtual_file_stats to measure the file activity – but that isn’t really correct. After all, your users run a lot of queries all day that are simply satisfied from the buffer pool. SQL Server caches your data so it doesn’t have to hit…
Read More

[Video] Watch Brent Work on sp_Blitz

sp_Blitz, Videos
11 Comments
During the quarantines, I’m looking for new ways to help you level up for free. I decided to start live-streaming whenever I’m working on things I can share with you publicly. I wanted to add a new check to sp_Blitz, so I figured I’d do it live on camera while you watch, and talk you…
Read More

[Video] What Percent Complete Is That Index Build?

SQL Server 2017 & newer have a new DMV, sys.index_resumable_operations, that show you the percent_completion for index creations and rebuilds. It works, but…only if the data isn’t changing. But of course your data is changing – that’s the whole point of doing these operations as resumable. If they weren’t changing, we could just let the operations…
Read More

[Video] Watch Brent Tune Queries

Execution Plans, Videos
13 Comments
Ever wonder somebody else does it? Watch over my shoulder as I spend 9 minutes in PowerPoint explaining the big picture, and then about 40 minutes working on this stored procedure in the StackOverflow2013 database: If you enjoy that, the Watch Brent Tune Queries page has another video and other query examples. Enjoy!
Read More
Menu