Forum Replies Created

Viewing 12 posts - 61 through 72 (of 72 total)

  • RE: very slow select

    Dear sir I tried creating index and it was taking a lot of time so had to stop it. Not sure how long it would run since it is prod...

    January 21, 2019 at 7:47 pm

    #2019580

  • RE: very slow select

    Jonathan AC Roberts - Monday, January 21, 2019 9:09 AM

    pietlinden - Monday, January 21, 2019 8:42 AM

    January 21, 2019 at 7:04 pm

    #2019578

  • RE: Replication error

    Sue_H - Monday, January 21, 2019 5:25 PM

    Tomys - Monday, January 21, 2019 1:47 PM

    January 21, 2019 at 5:41 pm

    #2019575

  • RE: very slow select

    Tomys - Monday, January 21, 2019 8:25 AM

    Jonathan AC Roberts - Monday, January 21, 2019 8:19 AM

    January 21, 2019 at 8:30 am

    #2019526

  • RE: very slow select

    Jonathan AC Roberts - Monday, January 21, 2019 8:19 AM

    It might be worth trying to rewrite the query. The query below is...

    January 21, 2019 at 8:25 am

    #2019524

  • RE: very slow select

    Jonathan AC Roberts - Monday, January 21, 2019 6:54 AM

    Tomys - Monday, January 21, 2019 6:45 AM

    January 21, 2019 at 7:03 am

    #2019512

  • RE: very slow select

    Jonathan AC Roberts - Sunday, January 20, 2019 9:26 AM

    Tomys - Sunday, January 20, 2019 6:43 AM

    January 21, 2019 at 6:45 am

    #2019510

  • RE: very slow select

    Jonathan AC Roberts - Saturday, January 19, 2019 7:21 AM

    8 hours sounds too much that simple query with that execution plan.
    How many...

    January 20, 2019 at 6:43 am

    #2019471

  • RE: very slow select

    saravanatn - Sunday, January 20, 2019 2:37 AM

    frederico_fonseca - Saturday, January 19, 2019 1:50 AM

    missing...

    January 20, 2019 at 6:38 am

    #2019470

  • RE: very slow select

    Eirikur Eiriksson - Sunday, January 20, 2019 2:55 AM

    Seen this too many times:pinch:
    😎
    Distinct sort for 380.000.000+ rows in parallel operation...

    January 20, 2019 at 6:36 am

    #2019469

  • RE: very slow select

    Thank you dear i’ll try the suggestions out..

    January 19, 2019 at 4:42 am

    #2019447

  • RE: very slow select

    I see what can be done to avoid distinct? Group by or something like that? Yeah those columns are included in the non clustered index

    January 18, 2019 at 7:37 pm

    #2019440

Viewing 12 posts - 61 through 72 (of 72 total)