SQL Server 2000 made some improvements to the English Query, Full Text
Indexing, OLAP, security, and web access functionality.  It has some IDE
improvements - most notable is the Object Viewer. Personally, as far as
I'm concerned the XML support that was added is what I consider most
significant.  Before placing any weight on that, keep in mind that only
a small number of people take advantage of this feature.  On the other
hand, if you look at the list of features slated for SQL Server 2005
("Longhorn"), many of themare XML-centric... Microsoft is obviously very
interested in making working with XML easier and more appealling from a
performance point of view
(http://www.microsoft.com/sql/yukon/productinfo/default.asp).  This
functionality really was introduced to SQL Server in version 2000.

~Simon

Simon Horwith
CTO, eTRILOGY ltd.
Member of Team Macromedia
Macromedia Certified Master Instructor
http://www.cfstandards.org

Chunshen (Don) Li wrote:

> Hi,
>
> If your shop or your clients run SQL Server 7 or 2000, what additional
> features/functions (possibly substantial) that you think would be very
> helpful to your organization or your client and why?
>
> Thank you.
>
> Don
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to