I am looking at upgrading our SQL Servers from 2005 Enterprise edition to SQL Server 2008 R2 Standard edition.
Obviously, the upgrade to 2008 R2 gives us more features even in Standard edition, but I am wondering what features will be lost by going from Enterprise down to Standard, if any.
I've tried searching around for this but there are only comparisons between editions on the same version (i.e. 2008 Standard vs Enterprise) not comparasions between different editions across different versions (i.e. 2005 Enterprise vs 2008 Standard).
Anyone got any advice or has any resource they can point me at?
thanks in advance.