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
1,048 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)
87,425 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
PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
A New Word: La Guadière
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Microsoft Purview data governance best practices
By James Serra
Microsoft Purview can be the best data governance tool in the world, but it...
Forums
non ascii columns in a utf-8 .txt file
hi, we couldnt get our upstream data source developers to supply what is sometimes...
PolyBase Trace Flags
Are there any good articles on all the trace flags that are enabled on...
The Data Model Matters
Comments posted to this topic are about the item The Data Model Matters
Question of the Day
Running SQLCMD I
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers