SQL Server 2005 and SQL Server 2008

Hi Arun,

here are some of differencese between sql 2005 & sql 2008 are:
Easy Upgrades: Version upgrades are now very easy and effective with SQL 2008.
Resource Restriction Governor: We set a restriction on a users or groups from consuming high resources. This is a very good feature that can be used on Windows shared server with SQL database to maintain the performance.
Dates and Times settings: New data types such as: Date, Time, Date Time Offset has been introduced.
Improved Full Text Search: Ability to backup Native Indexes and also thesaurus them as metadata.
External Key Management: This unique can store Keys separately and not with the data.
Improved SQL Server Analysis Service: It now has improved Stacks and computes block faster.
Improved Installation: Microsoft has added an option where you can uninstall Disk images and service packs.
Data Synchronizing: A Development of databases used in applications that frequently get disconnected.
Transparent Data Encrypts: It has the ability to encrypt full SQL database with different encryption Methods.
SQL Server Integration Service: SQL 2008 Server has improved multiprocessor support and faster lookups in compare to SQL 2005.
Change Data Capture: Allows all changes to be captured and queried. (Enterprise). Also allows us to get detailed information on what changes has happened to which rows after a specific version.
LINQ: A Development query language for accessing multiple type of data like XML and SQL at the same time.
Microsoft Office 2007 integration: One can use MS OFFICE as an SSRS template, like SSRS to WORD.
Spatial Data types: Data types for storing Longitude, Latitude and GPS entry of a particular database.
MERGE: A new TSQL command as a combination Update, Insert and Delete.
Encrypted Backups: We can execute it at the time running backups to prevent tampering from external resource.

Hope it helps!!!

Thanks,
Prasant

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Prasant Jinaga14y ago
Hi Arun,

here are some of differencese between sql 2005 & sql 2008 are:
Easy Upgrades: Version upgrades are now very easy and effective with SQL 2008.
Resource Restriction Governor: We set a restriction on a users or groups from consuming high resources. This is a very good feature that can be used on Windows shared server with SQL database to maintain the performance.
Dates and Times settings: New data types such as: Date, Time, Date Time Offset has been introduced.
Improved Full Text Search: Ability to backup Native Indexes and also thesaurus them as metadata.
External Key Management: This unique can store Keys separately and not with the data.
Improved SQL Server Analysis Service: It now has improved Stacks and computes block faster.
Improved Installation: Microsoft has added an option where you can uninstall Disk images and service packs.
Data Synchronizing: A Development of databases used in applications that frequently get disconnected.
Transparent Data Encrypts: It has the ability to encrypt full SQL database with different encryption Methods.
SQL Server Integration Service: SQL 2008 Server has improved multiprocessor support and faster lookups in compare to SQL 2005.
Change Data Capture: Allows all changes to be captured and queried. (Enterprise). Also allows us to get detailed information on what changes has happened to which rows after a specific version.
LINQ: A Development query language for accessing multiple type of data like XML and SQL at the same time.
Microsoft Office 2007 integration: One can use MS OFFICE as an SSRS template, like SSRS to WORD.
Spatial Data types: Data types for storing Longitude, Latitude and GPS entry of a particular database.
MERGE: A new TSQL command as a combination Update, Insert and Delete.
Encrypted Backups: We can execute it at the time running backups to prevent tampering from external resource.

Hope it helps!!!

Thanks,
Prasant
0