I've done a lot of this over the past year and have come to the conclusion that the Excel importing that SQL does is crap. You can't trust the...

Awesome article! However you mention nothing about speed. Is this method faster than doing an update to a single row? Can you elaborate more on the pros and cons of...