[Video] Office Hours: Ask Me Anything About SQL Server at Vestrahorn


The beach at Vestrahorn mountain looks different every time we’ve visited: high tide, low tide, sun, clouds. Always a fun side trip when we’re out in the southeast of Iceland. I took a break to answer the questions you upvoted here.

Questions we covered:

00:00 Introductions 00:38 Scott M: When do you recommend sp_BlitzWho vs sp_WhoIsActive? 03:15 Brandon: Does Clippy consider selectivity when building missing indexes? 05:10 Hugo: I have a temporary staging table whose statistics constantly update. Should I turn off automatic stats updates? 07:02 Kavia MP: Is RCSI a good alternative to NOLOCK? 07:31 Glev: Do you