Wednesday, October 27, 2010

DIFFERENCE BETWEEN SQLSERVER 2005 AND 2008

DIFFERENCE BETWEEN 2005 AND 2008:



































Feature NameSqlSearver 2005Sqlserver 2008
Backup CompressionNot availableAvailable
Page level compressionNot availableAvailable
Data CompressionNot availableAvailable
Clustering8 nodes are supported in Enterprise Edition16 nodes are supported in Enterprise Edition
Resource GovernorNot availableAvailable
File StreamNot availableAvailable
FacetsNot availableAvailable
EncryptionNot availableAvailable ( In mirroring all transactions are encrypted while moving data)

No comments:

Post a Comment