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.
Best Answer
How about that SQL 2005 will be out of support soon, so why install an almost dead product?
Having a policy that you only install two different versions of the product is a pretty stupid policy, especially if one of your versions is a dead product (SQL 2000 is a very dead product at this point).
Newer versions have a lot of performance improvements as well as new features. Without knowing what features you need I can't really comment on what features you'll be wanting to use.