I realize probably no one reads Books Online cover to cover, so there are probably lots of little details that easily slip by you. I was introduced to one of the hidden 'features' just last week. Here it is: CHECKPOINT can take a parameter! It's right there in BOL:  CHECKPOINT [ checkpoint_duration ] This parameter allows you to specify ...