Don’t miss these great articles on SQLPerformance.com from the industry’s top experts:
Erin Stellato (b | t) of SQLskills takes a deep look into the SQL Server performance impact, especially I/O, of running DBCC CHECKCONSTRAINTS, including explaining why some check methods may consume a lot more I/O than others.
Paul White (b| t) provides unique insight into a long-standing data modification issue, the infamous Halloween Problem. Much has been written over the years about understanding and optimizing SELECT queries, but rather less about data modification. This series examines an issue specific to the data modification statements of INSERT, UPDATE, DELETE and MERGE queries.