ICYMI: the Halloween Problem and DBCC CheckConstraints – SQL Server Performance

Don’t miss these great articles on SQLPerformance.com from the industry’s top experts:

A Look At DBCC CHECKCONSTRAINTS and I/O

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.

The Halloween Problem, Part 1 of a 4-Part Series

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.

 

Enjoy!

-Kev

-Follow me on Twitter!
-Google Author

Speak Your Mind

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.