• archu_223b4u (9/17/2008)


    Good question but can anyone help me where this is supports by SQL Server new version.

    It's still supported by SQL Server 2008, even though it's on the list of deprecated features. This means that nobody can tell (except maybe a few Mircosoft employees, but they won't) whether this feature will still be available in the next version of SQL Server (2011??), and whether some lower compatibility setting will be required by then.

    In other words - start investigating your code now, and if you use this feature, plan to replace your code somewhere over the following years. There's no rush, but you shouldn't postpone it either. And you definitely should not use GROUP BY ALL in new work.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/