Forum Replies Created

Viewing 11 posts - 1 through 11 (of 11 total)

  • Reply To: Implementing Date Calculations in SQL

    Hello,

    Going forward this post, I'd like to ask about my issue, that touching date and time subject.

    We use a Retail Calendar (445) which is different from the regular one. The...

  • RE: Dynamic creating indexes

    Lynn Pettis - Wednesday, September 12, 2018 11:20 AM

    Sababa - Wednesday, September 12, 2018 11:05 AM

    September 12, 2018 at 1:29 pm

    #2005495

  • RE: Dynamic creating indexes

    Lynn Pettis - Tuesday, September 11, 2018 2:34 PM

    Here is dynamic SQL that will generate the script you need.  It will be...

  • RE: Dynamic creating indexes

    Grant Fritchey - Wednesday, September 12, 2018 4:48 AM

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

    September 12, 2018 at 7:47 am

    #2005415

  • RE: Dynamic creating indexes

    jcelko212 32090 - Tuesday, September 11, 2018 7:50 PM

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

    September 12, 2018 at 7:37 am

    #2005411

  • RE: Dynamic creating indexes

    Thanks, I'll try it and update you

  • RE: Dynamic creating indexes

    No, they are all in the same format and logic, were issued once and if they disappear, I just run this script again

  • RE: Dynamic creating indexes

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

  • RE: Dynamic creating indexes

    I have more than 100 indexes.
    I can create just one procedure which is checking if the index exists, and run this one procedure every hour.
    My problem is to...

  • RE: Dynamic creating indexes

    Yeh, but for now my mission is to create this dynamic procedure, which will be checking the index existing and if doesn't exists, to create that.
    The problem is that...

  • RE: Dynamic creating indexes

    You're completely right, but it's not under our control.
    Unfortunately, we have a common DB with our ERP contractor and they may impact on that. when running any processes there.

Viewing 11 posts - 1 through 11 (of 11 total)