2008 DatabaseFeatures

  • what are the main Features in sql server 2008 database side, compare to 2005 database?

  • Lots of info on SQL 2008:

    http://www.microsoft.com/sqlserver/2008/en/us/default.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Some of the ones that I like are:

    * Compression for Backups, Log Backups, Log Shipping, Database Mirrioring

    * Compression in the engine for certain data types

    * new data type

    * SSMS enhancements for intellisense

    The link above will show a more comprehensive and more technical insight into the new features

    Thanks

    Kevin

  • Lots of new stuff,

    the one I use the most is the new Date data type;

    there is no longer the need to add an arbitrary time to date only records.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply