[thelist] Moving to ASP.Net

Ben Joyce ben.joyce at gmail.com
Wed Oct 8 16:14:29 CDT 2008


Hmm, I didn't know about Calculated Columns in 2005 - very useful
feature to have, thanks for the tip.

Incidently, I've decided to stop the 2005 testing i'm doing and go
straight to 2008 - we completely skipped a version in Production...
hurrah!

On Wed, Oct 8, 2008 at 9:25 PM, Christie Mason <CMason at managersforum.com> wrote:
> I'm not a DBA, database administrator, but here's a quick couple of benefits
> that I noticed when moving from 2000 to 2005.
>
> Less coding, faster response
> If your sites use calculations, you should check out the new capability to
> design computed columns so they persist - Example Column "oTotal"  can be
> automatically calculated as "oQty * oPrice" and you can then sum, count, etc
> "oTotal" w/o recalculating each time, or writing insert/update code to do
> the calculation.  These columns can now also be indexed.
>
> PIVOT/Crosstabs is also improved, though still not what I expected it to be.
>
> Christie Mason
>
>
> --
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>



-- 
http://www.flickr.com/photos/benbenbenbenben



More information about the thelist mailing list