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.
Monthly Archive: May 2018
T-SQL Tuesday #102 : Giving Back
I give some scattered thoughts about how I have contributed to the SQL Server community throughout my career.
Issue with UNION and columns with mismatched data types
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.