Calculated Column(s) or a View?
When to choose a Calculated Column(s) over a View?
Sorry, I forgot to mention that this is for SQL Server 2000.
i would prefer view, because calculated column is some view on your table data
I've come to prefer views over calculated columns. Most of the time, I can tolerate sluggishness on data retrieval (i.e. reporting, etc.), but not on inserts and updates. Any of the calculated columns I've ever used seemed to slow the insert/update by more than I liked.
Fog Creek Home