By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,211 Members | 2,227 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,211 IT Pros & Developers. It's quick & easy.

Table size and Computed Columns

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.