How to use OPENROWSET to preprocess data before importing...

Lately I have seen some quesitons on range locks. Why certain keys are locked? How is this behavior different for unique vs. non-unique indexes? So I played around with range locks and here are my findings so far. Range locks are obtained on index keys...

lock escalation...