Table size and Computed Columns

GJK

In SQL Sever, do the size of computed columns gets added to the total
size of the tables? Does SQL server stores the actual values in
computed columns?

Thanks
_GJK

Jul 23 '05 #1

Hugo Kornelis

On 8 Apr 2005 11:59:21 -0700, GJK wrote:

In SQL Sever, do the size of computed columns gets added to the total
size of the tables? Does SQL server stores the actual values in
computed columns?

Hi GJK,

Computed columns are not stored and don't add to the size of the tables,
unless you include them in a PRIMARY KEY or UNIQUE constraint.

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)

Jul 23 '05 #2