Lee Markum presents 'Buttons, Levers, and Dials: What to Do With Key SQL Server Settings!' at Nebraska.Code() this July.

https://nebraskacode.amegala.com/

#SQLServer #MAXDOP #CostThreshold #MAXServer #QueryStore #DBA #Developer #Microsoft #SQL #SoftwareDevelopment #TechConference #Nebraska #Heartland #Midwest #ProgrammingLife

PSA: If the devs or you are still using
IF EXISTS()
DROP PROCEDURE

CREATE PROC

and you have Query Store enabled where this is executing, then the objectid/queryid is changing for the proc every time this is ran. This means it becomes harder to track a proc in Query Store over time.

#sqlserver #querystore