"convert" tables to cluster columnstore indexes

• jCoke

  Ten Centuries

  Points: 1121

  More actions

  November 24, 2017 at 7:47 am

  #333862

  Hi all

  We have a few fairly large databases in production (about 2TB each) that i would like to convert into clustered columnstore indexes to save space, and while doing so i would like to test how all these non-clustered indexes are affecting performance, so i´ve created a lab environment for this purpose, but im now very skilled at managing data... i need help =D

  how do i convert all tables in a database into clustered columnstore indexes and drop all non-clustered indexes while being able to recreate all non-clustered indexes later on?

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  November 24, 2017 at 8:49 am

  #1969404

  Script the indexes, then drop them and the clustered index and create the clustered columnstore

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass