Why upgrade from SQL 2005 to SQL 2008 R2?
I have been tasked to write a document outlining the best reasons to use SQL 2008 R2 instead of SQL 2005 for my brand new BI project. We have a policy of only using two versions at a time and there are still SQL 2000 boxes around here somewhere....
I know the microsoft line on as per this link. http://www.microsoft.com/sqlserver/2008/en/us/why-upgrade.aspx
What I want to know is your opinions of which are the best features and why.
So if you can help me try to convince management to use a product which is actually up to date, I would appreciate it.