Computed Columns - Part 1

Computed columns are an interesting alternative to expressions in a stand alone select or a select contained in a view. Not something you'll use often, but good to know how it works.

Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

Not Available on 10/8/2009

I always used formula in a reporting query (or view)! Good to know.

Cory Ellingson on 10/8/2009

nice segway to the next video

Lloyd Edwards on 10/8/2009

very basic

Lourens on 10/9/2009

Looking forward to the guideline on when is the best time to use this.

Brad on 10/9/2009

Great - quick and too the point. These are great to watch quickly and pick up on daily tips. Thanks!

Deborah Land on 10/9/2009

Somewhat difficult to read the screen shots.

Rob Wingate on 10/9/2009

Andy rocks!

Al on 10/9/2009

Loved it. But wish it did not have a cliff hanger end. Indeed, what are the performance implications for both methods? Thanks

Al on 10/9/2009

Loved it. But wish it did not have a cliff hanger end. Indeed, what are the performance implications for both methods? Thanks

Michael Hauck on 10/12/2009

It was useful in terms of demonstrating technique but I feel it stopped short in terms of advantages vs views etc.

lewis on 10/13/2009

good stuff

A Alagu Ganesh on 1/8/2010

Good

alfred on 1/27/2010

good

ricardoacaraujo@hotmail.com on 3/24/2010

Rezoavel

Vasile on 6/18/2010

I would like to know if there are implications for Merge Replication when you use a computed column.

Susan Ray on 10/13/2010

Very Useful. Thank you.

FD928096BE on 10/14/2010

Good stuff!

FELIX on 11/2/2010

Excellent video

nilesh bilimoria on 11/17/2010

nice

Russell Tye on 12/12/2010

great...

Irfan Mohammed on 12/16/2010

Keep up the good work. Thanks for sharing.

Edward on 2/2/2011

Good video.

Janice Graver on 3/2/2011

awesome

Janice Graver on 3/2/2011

awesome

Richard Scott on 2/14/2012

Very useful - thanks!

Arif on 2/22/2012

GOOD AND STRAIGHT -NICE ONE

Diwakar on 2/22/2012

Nice

steve bergkamp on 2/22/2012

I would like to know what goes on behind the scenes. When a computed column is added to a table, what happens, does the optimizer complete the computation only when that column is referenced ? What if an index is placed on that column ?

Jason Yousef on 2/22/2012

Thanks Andy....

vick on 2/22/2012

Basics on Computed column good!!

naveengopinathasari on 2/22/2012

Good... but like to know more details about the advantages and disadvantages of using this computed column

Leonard Peoples on 2/22/2012

nice

Tim Eichelberger on 2/22/2012

I learned something new in 1 minute 57 seconds! I can see a few ways to use the computed column, thanks.

Yelena on 2/22/2012

Thanks!

John O'Sullivan on 2/22/2012

excellent demo

Mohd Sohel on 2/22/2012

It concatenation, does it also adjust the datatype as in oracle .

Dexter Jones on 2/23/2012

Concise yet informative.

Richard Scott on 2/23/2012

Very useful! Thanks.

Susan Ray on 2/24/2012

Nice to know I am doing this correctly.

Dan on 2/27/2012

Very good!

Nalasi Mendy on 3/5/2012

simple and easy to understand

Steve Duck on 3/27/2012

Love that the alternative was demo'ed and explained.