Monday, January 28, 2013

A Creative Use of Computed Columns

I love to see a creative solution to a technical problem.

How can I get that user out of my table quickly by JackLi

Great creative solution using indexed persisted computed columns.

The beauty of indexed persisted computed columns is that, yes, you have to pay the cost of doing the computation, but you only pay that cost at the point where you INSERT or UPDATE that particular column. If the data is mostly static as it is in this case, the one-time cost is very small.

No comments:

Post a Comment