[thelist] MS SQL Server - T-SQL

Ken Schaefer ken at adOpenStatic.com
Tue Aug 19 19:29:50 CDT 2003


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "barry sweeney" <barry at springcottage.ndirect.co.uk>
Subject: RE: [thelist] MS SQL Server - T-SQL


: Wow!
:
: Thanks Joshua and Tab, I've so much to learn!
:
: One question, I understand how this approach will ensure
: that there is never a synchronisation issue, but from an
: efficiency point of view, isn't it better to update one field
: once rather than 'recalculate' it everytime it's displayed?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Unless you're running the world's biggest board, I doubt you'd have problems
provided you use appropriate hardware, and appropriate indexes...

SQL Server is quite capable of scaling to ridiculous heights these days
(which doesn't help if you're using some kind of shared hosting plan, and
sharing the database server with 10,000 other users!)

However, to test, open Query Analyser, and hit the "Show Execution Plan"
button, and have a look at the estimated cost of your query.

Cheers
Ken



More information about the thelist mailing list