Opt In (Do Not Edit Here)

Showing posts with label Sql Server. Show all posts
Showing posts with label Sql Server. Show all posts

Sep 12, 2011

SQL SERVER 2005 Vs. SQL SERVER 2008



Parameters for Comparison SQL SERVER 2005 SQL SERVER 2008
Combined as  Sql Server Management Studio (SSMS) Sql Server Management Studio (SSMS)
XML DataType  Is Introduced Is Available
No. of Database can create 2(pow(20))-1  2(pow(20))-1 
Exception Handling Allowed Allowed
DDL Triggers  Allowed Allowed
DataBase Mirroring Allowed Allowed
Table fragmentation Allowed Allowed
Full Text Search Allowed Allowed
Bulk Copy Update Allowed Allowed
Encryption Not Available Allowed with entire database introduced in 2008 
Compression of tables and indexes  Allowed (Only Introduced in 2005 SP2) Allowed
Datetime DataType Used for both Date and Time  Date and Time DataTypes are seperately used for Date and Time DataType, Geospatial and TimeStamp with Internal Timezone is used 
Table DataType  Not Included Is Introduced
Microsoft SQL Server 2005 Integration Services (SSIS) Is Introduced Is Available
Central Management Server (CMS)  not available  Is Available
Policy based management (PBM)  not available  Is Available

All Rights Reserved. 2014 Copyright SIMPLITONA

Powered By Blogger | Published By Gooyaabi Templates Designed By : BloggerMotion

Top