471,887 Members | 1,048 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,887 software developers and data experts.

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
1 1315
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

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Jay | last post: by
1 post views Thread by utkanbir | last post: by
reply views Thread by utkanbir | last post: by
15 posts views Thread by kimi | last post: by
7 posts views Thread by slitvinov | last post: by
reply views Thread by YellowAndGreen | last post: by
reply views Thread by zermasroor | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.