SQL Server 2005 and SQL Server 2008

Question

Hi Ques What is the differences between SQL Server 2005 and SQL Server 2008 ?

Prasant Jinaga · Answer

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