Advantages of SQL Server 2008 over SQL Server 2005? [closed]

by
  • Transparent Data Encryption. The
    ability to encrypt an entire
    database.
  • Backup Encryption. Executed at
    backup time to prevent tampering.
  • External Key Management. Storing
    Keys separate from the data.
  • Auditing. Monitoring of data access.
  • Data Compression. Fact Table size
    reduction and improved performance.
  • Resource Governor. Restrict users or
    groups from consuming high levels or
    resources.
  • Hot Plug CPU. Add CPUs on the fly.
  • Performance Studio. Collection of
    performance monitoring tools.
  • Installation improvements. Disk
    images and service pack uninstall
    options.
  • Dynamic Development. New ADO and
    Visual Studio options as well as Dot
    Net 3.
  • Entity Data Services. Line Of
    Business (LOB) framework and Entity
    Query Language (eSQL)
  • LINQ. Development query language for
    access multiple types of data such
    as SQL and XML.
  • Data Synchronizing. Development of
    frequently disconnected
    applications.
  • Large UDT. No size restriction on
    UDT.
  • Dates and Times. New data types:
    Date, Time, Date Time Offset.
  • File Stream. New data type
    VarBinary(Max) FileStream for
    managing binary data.
  • Table Value Parameters. The ability
    to pass an entire table to a stored
    procedure.
  • Spatial Data. Data type for storing
    Latitude, Longitude, and GPS
    entries.
  • Full Text Search. Native Indexes,
    thesaurus as metadata, and backup
    ability.
  • SQL Server Integration Service.
    Improved multiprocessor support and
    faster lookups.
  • MERGE. TSQL command combining
    Insert, Update, and Delete.
  • SQL Server Analysis Server. Stack
    improvements, faster block
    computations.
  • SQL Server Reporting Server.
    Improved memory management and
    better rendering.
  • Microsoft Office 2007. Use OFFICE as
    an SSRS template. SSRS to WORD.
  • SQL 2000 Support Ends. Mainstream Support for SQL 2000 is coming to an end.

(Good intro article part 1, part 2, part 3.
As for compelling reasons, that depends on what you are using SQL server for. Do you need hierarchical data types? Do you currently store files in the database and want to switch over to SQL Server’s new filestream feature? Could you use more disk space by turning on data compression?

And let’s not forget the ability to MERGE data.

More Related Contents:

  1. Retrieving last record in each group from database – SQL Server 2005/2008
  2. SQL Server: How to permission schemas?
  3. Is it possible to write single query on two table which are not connected to each other?
  4. Base64 encoding in SQL Server 2005 T-SQL
  5. Integer division in sql server
  6. Nested stored procedures containing TRY CATCH ROLLBACK pattern?
  7. Querying data by joining two tables in two database on different servers
  8. How do I perform an accent insensitive compare (e with è, é, ê and ë) in SQL Server?
  9. SQL query to find Missing sequence numbers
  10. Is it possible to force row level locking in SQL Server?
  11. EXISTS vs JOIN and use of EXISTS clause
  12. How do I move files to an archive folder after the files have been processed?
  13. SQL Server GUID sort algorithm. Why?
  14. subquery or leftjoin with group by which one is faster?
  15. Calculating timespan with t-sql
  16. SQL Dynamic Pivot – how to order columns
  17. What happens to the primary key Id when it goes over the limit?
  18. Foreign key relationship with composite primary keys in SQL Server 2005
  19. Unique Key Violation in SQL Server – Is it safe to assume Error 2627?
  20. How to recover deleted rows from SQL server table?
  21. SQL Server 2005 – using generated sequences instead of Identity columns?
  22. How to create the linked server for SQL Server 2008 where we have the database from 2000 and 2005
  23. SQL . The SP or function should calculate the next date for friday
  24. Cumulative Total in MS Sql server [duplicate]
  25. “Prevent saving changes that require the table to be re-created” negative effects
  26. How do I find the data directory for a SQL Server instance?
  27. Table Valued Function Killing My Query Performance
  28. SQL Server: How to tell if a database is a system database?
  29. Multiple Select Statements using SQL Server 2005 “WITH” Statement
  30. How do you store a picture in an image column?

Leave a Comment