I want to add to the conversation, if I may.

The problem with the pattern "@XXX IS NULL OR XXX = @XXX" is that it ignores the indexes then.

Best regards

Andrew