Opt In (Do Not Edit Here)

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

About The Author :

Freelancer and IT Engineer
Softwares Developed by Mayur Dighe ImmortalDotNet.WordPress.com

0 comments :

All Rights Reserved. 2014 Copyright SIMPLITONA

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

Top