Are Cubes Dead?
Is the idea of an Analysis Services cube something that is no longer relevant for modern data analysis? Steve thinks it might be.
2022-06-06
385 reads
Cube
The Difference Between Rollup and Cube
Learn about the fundamental differences between the ROLLUP and CUBE operators.
2019-05-03 (first published: 2017-11-30)
58,005 reads
Questions About CUBE, ROLLUP and GROUPING SETs That You Were Too Shy to Ask
There are few parts of SQL Syntax as familiar as the GROUP BY clause of the SELECT statement. On the other hand, CUBE and ROLLUP remain mysterious despite their usefulness and GROUPING SET is positively arcane, especially if you are too shy to reveal your ignorance of the subject by asking! William Brewer saves you the hassle.
2015-11-17
4,187 reads
Blogs
Daily Coping 4 Jul 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
SQLServerCarpenter Tools
Over the past couple of years, I’ve developed several tools that I’ve been using...
usp_SQLServerCarpenter_Tools_Get_Procedures_Triggers_Missing_SET_NOCOUNT_ON
/* Author:Brahmanand Shukla (SQLServerCarpenter.com) Date:27-May-2022 Purpose:To get all the stored procedures and triggers missing the use of...
Forums
CAST AS DATE Assistance
Can someone let me know why I'm not able to use CAST method to...
Deploying a standalone Azure VM running SQL Server into an availability zone
If i deploy a standalone Azure VM running SQL Server into an availavility zone;...
SQL Server 2014 Question
So I have inherited an older SQL 2014 Server and have been working on...
Ask SSC