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 16 of 16   
 

Persisted Columns

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

Alter Column

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

Computed columns Data Types

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

Computed column

By Srikanth Soundararajan 2013/01/31 | Category: computed columns
Rating: (not yet rated) |  Discuss |   Briefcase | 2,197 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,326 reads

Computed Columns 1

By bitbucket-25253 2012/01/31 | Category: computed columns
Rating: (not yet rated) |  Discuss |   Briefcase | 2,306 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,890 reads

Persisted vs Non-persisted Computed columns

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

Index on computed columns

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

Computed Columns

By jghali 2010/07/21 | Category: computed columns
Rating: (not yet rated) |  Discuss |   Briefcase | 4,029 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,005 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 | 3,956 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,233 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,119 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,706 reads
   Items 1 to 16 of 16   
 
Tags
t-sql (10)    
indexing (2)    
performance tuning (2)    
tables (2)    
video (2)    
alter column (1)    
left() (1)    
like (1)    
quoted_identifier (1)    
reverse (1)    
string functions (1)    
unexpected query plan (1)    
xml (1)