Retrieve list of columnstore indexes. RRS feed

  • Question

  • Hi experts, 

    I have 5 sql instances and I need to quickly check if I have any columnstore index on any table of any db… Is there a quick way to check that? 

    (Furthermore I do not have much permissions on every instance, so ideally it would be a system table that I can access, even without even permissions on the db where the index resides?…) 

    Ps: One instance is Microsoft SQL Server 2008 R2 (SP1), I know I shouldn’t even check there because it was introduced in 2012, but is there anything similar to columnstore index on 2008 r2?

    Wednesday, April 27, 2016 11:39 AM