Re: Computer Columns

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Mark Allison (mark_at_no.tinned.meat.mvps.org)
Date: 02/02/05 

Date: Wed, 02 Feb 2005 11:00:16 +0000

Jonathan,

A computed column is not stored on disk unless an index is created on
it. So, it will be calculated at query time if there is no index. 

-- 
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Jonathan Martin wrote:
> Hi all,
> 
> I've been attempting to search for some documentation on how computer 
> columns are computed.  Firstly, does anyone have any?
> 
> If not, can any tell me at which point to column is computed?  Is it 
> computer at time of viewing, or is it computer as soon as the row is 
> created?
> 
> Thanks in advance.
> 
> 
> Jon
> 
>

Relevant Pages

  • Re: lock request time out period exceeded, error 1222
    ... right hand side tree and then select query time out option to zero (means ... MCITP SQL Server 2005 ... to onfigure the system to wait forever for this kind of locked table. ... I have tried to configure the "set lock timeout" configuration to -1 ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server 2000 query time out option, what does it do?
    ... > Can anyone tell me what the query time out is for? ... The query timeout is for queries to remote servers. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Variables in WHERE clause
    ... type in the WHERE clause values the query time is 1 second or ... clause the query takes 33 seconds. ... SQL Server compiles the batch in one go. ...
    (microsoft.public.sqlserver.programming)