All geek questions in one place

The difference between SQL Server 2005 and 2008

Can someone give me some description of the differences between SQL Server 2008 and SQL Server 2005?

Are there any changes to the update request or any new feature in the 2008 version?

+3
source share
2 answers

The most important, in my opinion, are:

  • MERGE
  • Chains OUTPUT
  • Ability to pass table variables to stored procedures
  • Native Materialized Path Support ( hierarchyid)
  • Filtered (Partial) Indexes
+2
source

What's New in Sql Server 2008 - MSDN link, full listing

What's new in Sql Server 2008 R2 - the same thing, but for version 2008 R2

Sql Server 2012 - , 2012

+3

Source: https://habr.com/ru/post/1785192/

More articles:


All Articles