Difference between SQL 2005 and SQL 2008 R2

Question

hi, can any one please let me know where cani find all the differences between SQL 2005 and SQL2008 R2. mostly looking for differences from BI perspective and Transact SQL.

Answer 1

The What's New topics in the SQL Server 2008 R2 Books Online cover the new features introduced by both SQL Server 2008 and SQL Server 2008 R2. You can navigate to the technologies you are interested in from the main What's New topic:

http://msdn.microsoft.com/en-us/library/bb500435.aspx

 

---

Alan Brewer [MSFT] SQL Server Documentation Team This posting is provided "AS IS" with no warranties, and confers no rights.