I have been assigned the task of designing a dimension or fact table for an EDW.
I know that a SQL Server table supports only one rowstore clustered index (conventional clustered index) and that you can create as many rowstore nonclustered indexes (conventional non-clusterd indexes) as required.
I would like to know if clustered columnstore and nonclustered indexes can be added to the same SQL Server table.
For instance, can I create a table with one rowstore clustered index (clusterd index), two nonclustered rowstore indexes (non-clustered indexes), and one nonclustered columnstore index?
Versions of the SQL Server database engine where we store our data: 2014, 2016, and 2017.