If you need to create a table and you want it to be partitioned right from the start, AND you want it to have a clustered columnstore index, here’s a creation T-SQL example:
CREATE TABLE dbo.MyTableName(
Id int IDENTITY(1,1),
SalesDate datetime NOT NULL,
INDEX MyIndexName CLUSTERED COLUMNSTORE
) ON ps_MyPartitionFunction(SalesDate);
The partition scheme name goes on the outside of the parenthesis, the index name goes on the inside, and the order of the whole thing is a little counter-intuitive.
That’s it. That’s the entire post. I just had to do that this morning and had a tough time finding an answer online, so figured I’d blog it. There you go.