CODEWITHSUNDEEP
sql-server
AsifQadri
AsifQadri

Reputation: 2388

Difference between SQL Server 2005 & 2008

Can anyone give me some description about differences between SQL Server 2008 and SQL Server 2005?

Are there changes comes in update query or any new feature in 2008 version?

Upvotes: 3

Views: 5090

Answers (2)

AdaTheDev
AdaTheDev

Reputation: 147224

What's New In Sql Server 2008 - MSDN reference, comprehensive listing

What's New In Sql Server 2008 R2 - same, but for 2008 R2 version

What's New In Sql Server 2012 - same, but for 2012 version

Upvotes: 3

Quassnoi
Quassnoi

Reputation: 425251

Most important, in my opinion, are:

  • MERGE
  • Chained OUTPUT
  • Ability to pass table variables into the stored procedures
  • Native support for materialized path (hierarchyid)
  • Filtered (partial) indexes

Upvotes: 2

Related Questions