Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag computed columns Rss

   Items 1 to 19 of 19   
 

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 | 5,845 reads

Deterministic

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

Computed Column

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

Persisted Columns

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

Alter Column

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

Computed columns Data Types

By Raul Gonzalez 2013/11/15 | Category: computed columns
Rating: (not yet rated) |  Discuss |   Briefcase | 1,917 reads

Computed column

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

A Computed Column Defined with a User-Defined Function Might Impact Query Performance

A benefit of using computed columns is that they can save developers from having to write calculation logic at the application layer; at the table level, the application can simply reference the computed column. In addition, performance can be improved by persisting a computed column and building an index on it.  Read more...
By Additional Articles 2012/02/03 | Source: SQLCAT | Category: computed columns
Rating:  Rate this |   Briefcase | 2,362 reads

Computed Columns 1

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

“QUOTED_IDENTIFIER” causes Unexpected Query Plan for Persisted Computed Column query

In this blog, you will see the reproducible steps that reveal the following observation: “If the table has a persisted computed column*, the query optimizer will choose a clustered index scan over a clustered index seek.”  Read more...
By Additional Articles 2011/10/28 | Source: SQLCAT | Category: quoted_identifier
Rating: (not yet rated)  Rate this |   Briefcase | 1,924 reads

Persisted vs Non-persisted Computed columns

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

Index on computed columns

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

Computed Columns

By jghali 2010/07/21 | Category: computed columns
Rating: (not yet rated) |  Discuss |   Briefcase | 4,041 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,024 reads

Adding a Computed Column to a Table (2) - SQL School Video

Part 2 of how to add a computed column to a table. MVP Andy Warren narrates this SQL School video.  Read more...
By Andy Warren 2009/06/25 | Source: SQLServerCentral.com | Category: video
Rating: |  Discuss |   Briefcase | 4,097 reads

Adding a Computed Column to a Table (1) - SQL School Video

In this SQL School video, Andy Warren shows how you can alter a table to add a computed column. This is part 1 of 2.  Read more...
By Andy Warren 2009/06/23 | Source: SQLServerCentral.com | Category: video
Rating: |  Discuss |   Briefcase | 4,439 reads

How to create indexes on computed columns in SQL Server

There are certain requirements for creating indexes on computed columns and this tip shows you want needs to be done.  Read more...
By Additional Articles 2009/03/18 | Source: SQLServerCentral.com | Category: indexing
Rating:  Rate this |   Briefcase | 3,230 reads

Create a computed column in SQL Server using XML data

Create a computed column in SQL Server using XML data and optimize SQL queries. Learn how to create a function for XQuery and use it within the computed column formula.  Read more...
By Additional Articles 2008/06/25 | Source: SearchSQLServer | Category: xml
Rating:  Rate this |   Briefcase | 2,769 reads
   Items 1 to 19 of 19   
 
Tags
t-sql (13)    
xml (3)    
indexing (2)    
performance tuning (2)    
tables (2)    
video (2)    
alter column (1)    
check constraints (1)    
default constraints (1)    
deterministic (1)    
left() (1)    
like (1)    
persisted (1)    
quoted_identifier (1)    
reverse (1)    
scalar udf (1)    
string functions (1)    
unexpected query plan (1)