Big news at today’s Microsoft Connect conference: Service Pack 1 is out.
The list of features is awesome, but here’s the biggest news: almost all of the features of Enterprise Edition are now available in Standard Edition. That’s right: it’s time to get jiggy with the online index rebuilds, partitioning, compression, and more.
There’s one big restriction: for more than 4 sockets, more than 24 cores, or more than 128GB RAM, you’ll need Enterprise Edition.
After installing SP1, make sure to revisit your maintenance plans and index rebuild scripts – time to start taking advantage of online index rebuilds. Enjoy!