szmulder (9/30/2010)
Only enterprise version support this function, too expensive!I think most company only buy standard version that's why most people never have chance to use it.
I think you'd be wrong on that one. All the companies I have worked for (4 in the last 5 years) have had multiple instances of Enterprise Edition across different versions of SQL Server.
Good article, about to go into this in more detail over the next couple of days (looking at implementing on one of our PROD systems), so should be fun!