Cube-like functionality in SQL 2008.
Today I took a look at the usefulness of the new GROUPING SETS clause in SQL Server 2008. The results of the GROUPING SETS clause can be achived in other ways, but it takes more programming work to do so. Next time I will take a look at SQL Server 2008 enhancements to the CUBE and ROLLUP; two constructs that can produce similar results to the GROUPING SETS clause, but in a different manner.
Using Grouping Sets in SQL Server 2008 | Servers and Storage | TechRepublic.com
No comments:
Post a Comment