THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Kevin Kline

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 I/O impact 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 (bt) 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!

Published Monday, March 2, 2015 10:02 AM by KKline

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
(required) 
Submit

About KKline

Kevin Kline is a well-known database industry expert, author, and speaker. Kevin is a long-time Microsoft MVP and was one of the founders of PASS, www.sqlpass.org.

This Blog

Syndication

Archives

Privacy Statement