SQL Server Update Best Practices

Hi,

I work on a case where a C# application receives Transactions and Transactions lines and then execute an update SP for both Transactions and TransactionLines. No validation are done and all Transaction Lines will be fully updated even if no changes happened. I feel it's not good at all, but C# developpers don't like to test every single fields to check if changes occured and then issue the Update anyways.

I know the answer to this question depends greatly on volume and size of the database and tables and how often you will save an update, but I would like to know general considerations and best practices on this.

Thanks