Table size and Computed Columns

#1

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

#2

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

Quote:

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)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Table size and Computed Columns

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Table size and Computed Columns - 04-08-2005 , 01:59 PM

Re: Table size and Computed Columns - 04-08-2005 , 02:38 PM