Welcome Back to VertiPaq
To bring this conversation full circle, let’s create a columnstore index on the FactResellerSales table in AdventureWorksDW2012 (which corresponds to the Sales table in our model). Here are the necessary steps:
Connect to your SQL Server relational server in SSMS.
Drill down on the Datab`ases node.
Drill down on the child AdventureWorksDW2012 node.
Drill down on the child Tables node.
Drill down on the child dbo.FactResellerSales node.
Right-click the child Indexes node and select New Index | Non-Clustered Columnstore Index from the context menu.
In the New Index dialog, click the Add button.
The Select Columns dialog box will then come up. Click the select-all checkbox at the far left of the gray-backgrounded column headers bar, ...
Get Programming Microsoft® SQL Server® 2012 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.