8.RowNumber function for paging 9.Table fragmentation 10.Full Text Search 11.Bulk Copy Update 12.Can encrypt the entire database introduced in 2008. 13.Can compress tables and indexes. 14.Date and time are seperately used for date and time datatype,geospatial and timestamp with internal timezone is used. 15.Varchar(max) and varbinary(max) is used. 16.Table datatype introduced. 17.SSIS avails in this version. 18.Central Management Server(CMS) is Introduced. 19.Policy based management(PBM) server is Introduced. SQL Server 2012 & 2014: Express Business with Feature Web with Name Tools Services Maximum Operating Limited to Limited Limited to Limited Limited Compute System lesser of 4 to lesser to lesser of 1 to lesser to lesser Capacity maximum Sockets or of 4 lesser Socket or of 1 of 1 Used by a 16 cores Sockets of 4 4 cores Socket Socket Single or 16 Sockets or 4 or 4 Instance cores or 16 cores cores (SQL Server Database Engine)1 Maximum Operating Operating Limited Limited to Limited Limited Compute system system to lesser to lesser of 1 to lesser to lesser Capacity maximum maximum of 4 lesser Socket or of 1 of 1 Used by a Sockets of 4 4 cores Socket Socket Single or 16 Sockets or 4 or 4 Instance cores cores
8.RowNumber function for paging 9.Table fragmentation 10.Full Text Search 11.Bulk Copy Update 12.Can encrypt the entire database introduced in 2008. 13.Can compress tables and indexes. 14.Date and time are seperately used for date and time datatype,geospatial and timestamp with internal timezone is used. 15.Varchar(max) and varbinary(max) is used. 16.Table datatype introduced. 17.SSIS avails in this version. 18.Central Management Server(CMS) is Introduced. 19.Policy based management(PBM) server is Introduced. SQL Server 2012 & 2014: Feature Name Business Web Express with Services with Tools Maximum Compute Capacity Used by a Single Instance (SQL Server Database Engine)1 Operating System maximum Limited to lesser of 4 Sockets or 16 cores Limited to lesser of 4 Sockets or 16 cores to lesser of 4 Sockets or 16 Limited to lesser of 1 Socket or 4 cores Limited to lesser of 1 Socket or 4 cores Limited to lesser of 1 Socket or 4 cores Maximum Compute Capacity Used by a Single Instance Operating system maximum Operating system maximum Limited to lesser of 4 Sockets or 16 cores to lesser of 4 Sockets Limited to lesser of 1 Socket or 4 cores Limited to lesser of 1 Socket or 4 cores Limited to lesser of 1 Socket or 4