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

Articles with tag computed column Rss

Search for any content tagged computed column

   Items 1 to 7 of 7   
 

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 column
Rating:  Rate this |   Briefcase | 2,299 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,856 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 | 8,995 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,839 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,090 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,066 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,674 reads
   Items 1 to 7 of 7