P0034 – Choose the best columnstore index for your needs

[Peter Jones]

A very good article on column store

https://learn.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes-design-guidance?view=sql-server-ver16

Also worth reading.

https://www.mssqltips.com/sqlservertip/7691/rowstore-columnstore-index-sql-server/?utm_content=but

Best Regards
Peter Jones

[Author]

Posts