SQL Server Performance

Computed columns vs computed in a trigger?

Discussion in 'T-SQL Performance Tuning for Developers' started by vbweb, Jul 15, 2004.

  1. vbweb New Member

    Hi,

    I was wondering if someone could explain how exactly computed columns work - does SQL Server effectively just recalculate the value whenever a row is inserted or updated? Are there any advantages updating the value in a trigger over a calculated column? (aside from the fact you can perform more complex calculations in a trigger)

    Cheers,

    ~ James
  2. satya Moderator

Share This Page