SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, computed columns Rss

   Items 1 to 15 of 15   
 

Indexing a Computed Column

By Steve Jones 2018/08/23 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 781 reads

Changing an INCLUDEd column

By Steve Jones 2015/12/18 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,588 reads

The Case for Scalar-valued, User-defined Functions in T-SQL

Did you know that scalar-valued, user-defined functions can be used in DEFAULT/CHECK CONSTRAINTs and computed columns? Learn about it...  Read more...
By Dwain Camps 2015/05/12 | Source: SQLServerCentral.com | Category: scalar udf
Rating: |  Discuss |   Briefcase | 6,252 reads

Deterministic

By Stewart Campbell 2015/04/16 | Category: computed columns
Rating: (not yet rated) |  Discuss |   Briefcase | 1,638 reads

Computed Column

By Stewart Campbell 2015/04/14 | Category: computed columns
Rating: (not yet rated) |  Discuss |   Briefcase | 1,739 reads

Persisted Columns

By Steve Jones 2014/09/02 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,050 reads

Alter Column

By Shanjan Sapra 2014/04/30 | Category: computed columns
Rating: (not yet rated) |  Discuss |   Briefcase | 1,930 reads

Computed column

By Srikanth Soundararajan 2013/01/31 | Category: computed columns
Rating: (not yet rated) |  Discuss |   Briefcase | 2,250 reads

Computed Columns 1

By bitbucket-25253 2012/01/31 | Category: computed columns
Rating: (not yet rated) |  Discuss |   Briefcase | 2,353 reads

Persisted vs Non-persisted Computed columns

By VM-723206 2010/10/07 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,007 reads

Index on computed columns

By VM-723206 2010/09/28 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,821 reads

Computed Columns

By JohnG69 2010/07/21 | Category: computed columns
Rating: (not yet rated) |  Discuss |   Briefcase | 4,065 reads

Optimising “Ends With” searches with REVERSE

A simple way to improve performance for queries that use the LIKE operator. Ben Seaman shows how to deal with searches that look at the end of a piece of text  Read more...
By Ben Whitman 2010/01/13 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 9,108 reads
   Items 1 to 15 of 15   
 
Tags
indexing (2)    
xml (2)    
alter column (1)    
check constraints (1)    
default constraints (1)    
deterministic (1)    
left() (1)    
like (1)    
performance tuning (1)    
persisted (1)    
reverse (1)    
scalar udf (1)    
string functions (1)