Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2005
    Posts
    2

    Question Unanswered: Advanatages of SQL 2005???

    Can someone outline the advantages of SQL 2005 over SQL 2000 and why a company would want to upgrade from SQL 2000 to SQL 2005?

    Thank you

  2. #2
    Join Date
    Apr 2005
    Posts
    16

    Info...

    Here is a quick summary of some differences/advantages of 2005

    http://www.aspfaq.com/show.asp?id=2343

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    It would ultimately depend on the company's requirements, and how willing they are to get there. For example, is this company willing to send someone from the IT department to train on SQL 2005?
    As for the benefits, the one benefit all applications will derive is that SQL 2005 is generally faster than SQL 2000. You can't put a real factor of speed increase on it, but I have seen up to 4 times faster on the same hardware. That could be because I am lucky when I pick my examples, though.
    If you are willing to put development effort into an application, you can get built-in encryption for sensitive data, built-in partitioning for large sets of data, or any of the bolt-on applications Microsoft is pushing with the SQL Licenses these days (Reporting Services, Notification Services, Analysis Services, or Integration Services). Outside of that, you would have to look at and probably test your application on 2005 to see what you get out of it.

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Also MS weblinks for more information (though they talk more about their product)
    http://www.microsoft.com/sql/prodinf...s/default.mspx
    http://www.microsoft.com/sql/downloa...-software.mspx
    1. SQL Server Integration Services is the new version of DTS. It is a complete rewrite of the product rather than an upgrade and will put give MS an ETL tool on an equal footing with the big ETL players.
    2. Analysis Services has been completely re-architected to include (such as) multiple hierarchies in a dimension, KPIs, perspectives, and many other things all hosted in a new conceptual object called the Unified Dimensional Model (UDM).
    3. CLR Integration - Stored procedures/functions can now be written in a .Net language.
    4. Table partitioning improvements
    5. Reporting Services enhancements
    ... for more list of features refer to above links.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •