Differences between SQL Server 2005 and SQL Server 2008

• pvsrpk

  SSChasing Mays

  Points: 602

  More actions

  March 17, 2010 at 6:02 am

  #221917

  Hi all,

  I am new to SQL SERVER.

  Could anybody give me the list of differences between SQL SERVER 2005 and 2008.

  It may be in any aspect either in architecture,or in features or in DBA related or SSIS related or it may be any concept related to SQL server.

  Please list the new features in SQL 2008 too.

  Thanks in advance.

• Kingston Dhasian

  SSCoach

  Points: 19799

  More actions

  March 17, 2010 at 6:20 am

  #1135149

  This will be a useful link for you..

  http://www.sqlservercentral.com/articles/SQL+Server+2008/65539/

  ---

  Kingston Dhasian

  How to post data/code on a forum to get the best help - Jeff Moden
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

• WayneS

  SSC Guru

  Points: 95460

  More actions

  March 17, 2010 at 7:21 am

  #1135208

  This will list a few things...

  http://www.lmgtfy.com/?q=sql+server+2008+what%27s+new

  Wayne
  Microsoft Certified Master: SQL Server 2008
  Author - SQL Server T-SQL Recipes

  ---

  If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

  ---

  Links:
  For better assistance in answering your questions
  Performance Problems
  Common date/time routines
  Understanding and Using APPLY Part 1 & Part 2

• vidya_pande

  SSCertifiable

  Points: 5275

  More actions

  March 17, 2010 at 7:31 am

  #1135216

  This is detailed link from SQL Server 2008 microsoft website-

  http://www.microsoft.com/sqlserver/2008/en/us/whats-new.aspx