SQL #57–A one-liner query with PARTITION BY
What can be done in SAS must be possible in SQL
A friend of mine is a data professional in marketing data...
2015-01-22 (first published: 2015-01-17)
10,455 reads
What can be done in SAS must be possible in SQL
A friend of mine is a data professional in marketing data...
2015-01-22 (first published: 2015-01-17)
10,455 reads
If learning SQL is in your New Year Resolution, then you will be happy to read this post.
We all make...
2015-01-09
1,047 reads
It’s hard to believe that it’s been 5 years since my first ever post, in which I simply spelled Business Intelligence. Thanks...
2014-12-31
1,050 reads
ROLLUP, CUBE, and GROUPING SETS Operators have been around since SQL Server 2005. These operators are extensions of the GROUP...
2015-01-05 (first published: 2014-12-31)
8,628 reads
When we design a database, we usually need to do an estimate on the size of the database based on the...
2014-12-19
1,101 reads
OLEDB is the native client for SQL Server. Every SSIS developer is familiar with how to use it. Almost every...
2014-12-23 (first published: 2014-12-17)
7,873 reads
The Analysis Services Performance Guide from bunch of Microsoft Analysis Services experts have been updated since 2005 edition for 2008 R2...
2014-12-14
1,492 reads
MSOLAP is a native OLE DB provider for Analysis Services
A common task during ETL is to process the OLAP dimensions and the...
2014-12-13
3,101 reads
Now we know how to find all the calculation scripts in a cube by querying the DMV $SYSTEM.MDSCHEMA_MEASURES.
MDX #43–Find a MDX...
2014-11-21 (first published: 2014-11-14)
5,730 reads
Calculated measures are visually identifiable
If you have access to a cube, it’s quite easy to find all the calculated measures.
The...
2014-11-13
1,469 reads
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
If you’ve been watching AI roll through the data community and thinking, “this seems...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Comments posted to this topic are about the item Spending Time in the Office
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers