New features in different version of SQL SERVER
SQL SERVER 2000 Query Analyzer and Enterprise manager are separate We can create maximum of 65,535 databases. SQL SERVER 2005 Query Analyzer and Enterprise manager are combined as SSMS(Sql Server management Studio) XML data type is introduced We can create 2(pow(20))-1 databases We can compress the tables and indexes Varchar(max) or Varbinary(max) is available SSIS is started using PIVOT and UNPIVOT functions are introduced. Database can encrypt SQL SERVER 2008 We can able to Encrypt the entire Database Introduced Back-Up Encryption. XML Datatype is implemented and used. FILESTREAM Datatype is introduced LINQ is introduced for retrieving multiple types of data Table-Valued Parameters is introduced Merge Statement is included Major Changes in DateTime -DATE, TIME, DATETIMEOFFSET, DATETIME2 The restriction has been removed for UDTs( In 2005, UDTs where restricted to max. size of 8 KB) Data Synchronization is introduced. It support maximum of 64 logical pro