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

Share and Enjoy:
  • Print
  • Digg
  • StumbleUpon
  • del.icio.us
  • Facebook
  • Yahoo! Buzz
  • Twitter
  • Google Bookmarks
  • email
  • LinkedIn
  • Ping.fm
  • HackerNews
  • Posterous
  • Reddit
  • Technorati
  • Tumblr

Trackbacks

  1. SQL Server says:

    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

  2. […] post ICYMI: the Halloween Problem and DBCC CheckConstraints – SQL Server Performance appeared first on Kevin […]

Speak Your Mind

*