Affect all triggers at once with dynamic SQL
I show how to enable, disable, drop, and re-create all triggers in a database using dynamic SQL.
I show how to enable, disable, drop, and re-create all triggers in a database using dynamic SQL.
I give some scattered thoughts about how I have contributed to the SQL Server community throughout my career.
Estimated data size as a result of implicit conversions can make a huge difference in the execution plan. SentryOne Plan Explorer lets you spot it early.