SQLServerCentral.com Articles tagged computed column

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

Fri, 03 Feb 2012 07:00:00 UT

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.

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

Fri, 28 Oct 2011 06:00:00 UT

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.”

Optimising “Ends With” searches with REVERSE

Wed, 13 Jan 2010 07:00:00 UT

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

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

Thu, 25 Jun 2009 06:00:00 UT

Part 2 of how to add a computed column to a table. MVP Andy Warren narrates this SQL School video.

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

Tue, 23 Jun 2009 06:00:00 UT

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.

Database source control in just 5 minutes
It takes just 5 minutes to connect your SQL databases to source control. Got 5 minutes to spare? Get started now.

How to create indexes on computed columns in SQL Server

Wed, 18 Mar 2009 06:00:00 UT

There are certain requirements for creating indexes on computed columns and this tip shows you want needs to be done.

Create a computed column in SQL Server using XML data

Wed, 25 Jun 2008 06:00:00 UT

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.

12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.