find indexes

• ramrajan

  SSCommitted

  Points: 1737

  More actions

  October 23, 2017 at 5:31 am

  #340902

  I have to design a script to find all tables in a database with below criteria.
  1. Identify all tables should have more than one million records and doesn't have any columnstoreindex on it.
  2. Identify all the tables which contain both columnsstoreindex and non-clustered index.

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  October 23, 2017 at 6:45 am

  #1964759

  Duplicate post, https://www.sqlservercentral.com/Forums/1903844/Find-tables

• ramrajan

  SSCommitted

  Points: 1737

  More actions

  October 23, 2017 at 6:47 am

  #1964762

  But nobody replied

• NorthernSoul

  SSCertifiable

  Points: 6869

  More actions

  October 23, 2017 at 7:05 am

  #1964764

  ramrajan - Monday, October 23, 2017 6:47 AM

  But nobody replied

  Yes they did, you were given all the information you need to write the query yourself. Have you tried?

  Thanks

• ramrajan

  SSCommitted

  Points: 1737

  More actions

  October 23, 2017 at 7:22 am

  #1964767

  I have tried but no luck.

• Thom A

  SSC Guru

  Points: 99133

  More actions

  October 23, 2017 at 7:49 am

  #1964774

  ramrajan - Monday, October 23, 2017 7:22 AM

  I have tried but no luck.

  Go back to your original topic, and post what you've most recently tried please. 🙂

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk