Post reply

find indexes

  • 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.

  • October 23, 2017 at 6:45 am

    #1964759

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

  • October 23, 2017 at 6:47 am

    #1964762

    But nobody replied

  • 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

  • October 23, 2017 at 7:22 am

    #1964767

    I have tried but no luck.

  • 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

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply