Saturday, January 2, 2010

New Features in Sql Server 2008


  • Compressed Backup
  • AUDITING => Change Data Capture (CDC)
  • FileStream
  • Sparse Column Support
  • Performance Data Management
  • Encryption => Transparent data encryption (TDE)
  • Resource Governor
  • Freeze Plan
  • LINQ Support

Deprecated Features in future realases (but still available in Sql 2008)

  •  BACKUP {DATABASE | LOG} WITH PASSWORD
  •  BACKUP {DATABASE | LOG} WITH MEDIAPASSWORD
  •  RESTORE {DATABASE | LOG} … WITH DBO_ONLY
  •  RESTORE {DATABASE | LOG} WITH PASSWORD
  •  RESTORE {DATABASE | LOG} WITH MEDIAPASSWORD

Posted by at

1 comment:

  1. BijayaniJanuary 25, 2010 at 3:04 PM

    Hi,

    I happened to see your post and would like to share a link where a software engineer has shared a tip on "Consuming No space for storing NULL value in table". As we know while designing a table we create columns too but these columns are rarely used and they take NULL value and as well as they occupy some memory space. But we can avoid it with the feature of SQL Server 2008 i.e Sparse Column.

    Here is the link where the software engineer has done a coding on the above mentioned issue:
    http://www.mindfiresolutions.com/consuming-no-space-for-storing-null-value-in-table-287.php

    Hope you find it useful and of assistance.

    Thanks for sharing such a valuble information.
    Bijayani

    ReplyDelete

Subscribe to: Post Comments (Atom)

Share This