Forum Replies Created

Viewing 15 posts - 1,036 through 1,050 (of 26,490 total)

  • RE: Dynamic creating indexes

    ScottPletcher - Tuesday, September 11, 2018 4:28 PM

    My preference has been to store the original sys.indexes and sys.index_columns rows rather than storing...

  • RE: Restore backup from SQL 2017 to SQL 2008

    farik013 - Wednesday, September 12, 2018 7:36 AM

    Hi. There is a lot of post about my question, but I have little different...

  • RE: Coming down on bad users - WWYD ?

    JaybeeSQL - Tuesday, September 11, 2018 2:24 PM

    It didn't come across as an attack, but a lack of solidarity.  What pains...

  • RE: Dynamic creating indexes

    Here is dynamic SQL that will generate the script you need.  It will be initially displayed in a column in grid mode, left clink on the link and it will...

  • RE: Dynamic creating indexes

    Or filtered indexes?

  • RE: Dynamic creating indexes

    Do we need to worry about filestream data in the indexes?

  • RE: Dynamic creating indexes

    Are the indexes create in non-standard location(s) such as different file groups from the tables?

  • RE: Dynamic creating indexes

    Sababa - Tuesday, September 11, 2018 12:36 PM

    We don't have there any clustered indexes and there are no primary or unique. Only...

  • RE: Dynamic creating indexes

    Can we assume that the clustered index is not dropped?  How about indexes supporting constraints like primary or unique indexes?

  • RE: Dynamic creating indexes

    Script each index while they exist in the database.  Put each in their own stored procedure.  Use a master procedure to call each individual procedure if the index is missing.

  • RE: Best Practice Help - Table Structures

    Document everything, make sure all (ALL) changes are in writing.  Keep your proposed design handy.  At some point the data in the system will hit critical mass and performance will...

  • RE: Dynamic creating indexes

    irit.schwarts - Tuesday, September 11, 2018 9:26 AM

    You're completely right, but it's not under our control.
    Unfortunately, we have a common DB with...

  • RE: Dynamic creating indexes

    If you have to keep recreating the indexes I would look for the process(es) that are dropping the indexes and fix that so the indexes don't keep disappearing.

  • RE: Coming down on bad users - WWYD ?

    JaybeeSQL - Monday, September 10, 2018 11:02 PM

    We're not here to babysit incompetent users, but to safeguard our employers from them. ...

  • RE: Oracle query tuning

    If you work regularly with Oracle I would also push for Toad for Oracle.  It will provide tools for query performance tuning.  Not free, but if I had to work...

Viewing 15 posts - 1,036 through 1,050 (of 26,490 total)