[Video] Office Hours Manhattan Edition: Ask Me Anything About SQL Server

I sat down on the edge of Brooklyn, overlooking the Manhattan skyline, to take your highest-voted questions from https://pollgab.com/room/brento.

Here’s what we covered:

00:00 Introductions 00:42 Dylan: Do you have any experience with sys.dm_db_tuning_recommendations? To be clear, I am not referring to Azure SQL or Automatic Index Tuning, but rather Query Store Forcing/Unforcing plans automatically. Even if not set to automatic, have you seen clients manually utilize this data? 02:27 Borninthematrix: Hi Brent, we frequently get deadlock on thread errors as opposed to on a specific resource. I can use sp-blitzlock to pull out the query plan, but do