The begin/end optional (usually) syntax makes me crazy. I only use it when required, it just adds noise.
Agreed. However, same for the NO COUNT ON. I don't use it unless there would be a demonstrated need for it. There are many times the rowcount has been necessary. Using this command just limits options.