• When do checkpoints happen? Are they automatic? Can they be invoked programmatically?

    Besides simple recovery, are there other techniques to minimize the size of the transaction log?

    Thank you,

    Jake