Lowest cost in a record
-
The update is done once a day in the morning. Is that still taxing on the hard drives?
-
Actually yes.
There are 2 issues in your approach:
1. You are doing full updates even if nothing changed in the table;
2. Data in your "updated" column is inconsistant with the rest of the data for almost every moment of time, except that single second at morning when this column has just been updated.
Computed column will provide immediate update with minimal overheads. No table updates, no scheduled jobs, no maintenance plans. And always reliable data.
_____________
Code for TallyGenerator -
and as it was mentioned Don't forget to create an index on the computed column or the benefits will be marginal
* Noel
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply