Forum Replies Created

Viewing 15 posts - 1 through 15 (of 180 total)

  • RE: Intermittent poor query performance

    Hi thought I'd provide an update. thanks for your advice Grant, as a result i have implemented a weekly update stats routine prior to the user's process running and so...

    April 27, 2016 at 7:47 am

    #1874941

  • RE: Intermittent poor query performance

    Well I have all but ruled out resource contention on account of the differing number of reads, as well as some comparisons I have made re resource usage. Pretty similar...

    March 28, 2016 at 10:58 am

    #1868033

  • RE: Intermittent poor query performance

    Think i have spotted something.

    In the attachment i added to this post each of the sp_execute commands is doing at least three times the number of reads as the corresponding...

    March 27, 2016 at 3:10 pm

    #1867902

  • RE: Intermittent poor query performance

    Thanks Grant I will upload the plans when I am able, to provide a bit more to go on.

    I see your point about the same plan not necessarily being...

    March 25, 2016 at 9:30 am

    #1867756

  • RE: Today's Random Word!

    Revenant (6/3/2015)

    cunningham (6/3/2015)

    Eirikur Eiriksson (6/3/2015)

    crookj (6/3/2015)

    Ed Wagner (6/3/2015)

    Eirikur Eiriksson (6/2/2015)

    Ed Wagner (6/2/2015)

    cunningham (6/2/2015)

    Eirikur Eiriksson (6/2/2015)

    Ed Wagner (6/2/2015)

    whereisSQL? (6/2/2015)

    Revenant (6/2/2015)

    DonlSimpson (6/2/2015)

    cunningham (6/2/2015)

    Ed Wagner (6/2/2015)

    cunningham (6/2/2015)

    Ed Wagner (6/2/2015)

    crookj (6/2/2015)

    Eirikur Eiriksson (6/1/2015)

    Revenant (6/1/2015)

    TomThomson...

    June 3, 2015 at 9:38 am

    #1802703

  • RE: What Not To Say

    Company X has offered me $yyyyy. Will you match it?

    Annoyingly my mate has used this successfully TWICE! But there were very long intervals between each time!

    June 3, 2015 at 9:23 am

    #1802694

  • RE: Today's Random Word!

    Eirikur Eiriksson (6/3/2015)

    crookj (6/3/2015)

    Ed Wagner (6/3/2015)

    Eirikur Eiriksson (6/2/2015)

    Ed Wagner (6/2/2015)

    cunningham (6/2/2015)

    Eirikur Eiriksson (6/2/2015)

    Ed Wagner (6/2/2015)

    whereisSQL? (6/2/2015)

    Revenant (6/2/2015)

    DonlSimpson (6/2/2015)

    cunningham (6/2/2015)

    Ed Wagner (6/2/2015)

    cunningham (6/2/2015)

    Ed Wagner (6/2/2015)

    crookj (6/2/2015)

    Eirikur Eiriksson (6/1/2015)

    Revenant (6/1/2015)

    TomThomson (6/1/2015)

    DonlSimpson (6/1/2015)

    Sprint

    Borland

    Delphi[/quoteZeus

    Mercury

    Saturn

    Megadrive

    Sega...

    June 3, 2015 at 8:54 am

    #1802675

  • RE: Are the posted questions getting worse?

    Lynn Pettis (6/2/2015)

    SMH...

    Why would the person who wrote the procedure ask on a public forum why his procedure is returning a value of -6 when executed?

    I was waiting for this...

    June 2, 2015 at 1:30 pm

    #1802427

  • RE: Today's Random Word!

    Eirikur Eiriksson (6/2/2015)

    Ed Wagner (6/2/2015)

    whereisSQL? (6/2/2015)

    Revenant (6/2/2015)

    DonlSimpson (6/2/2015)

    cunningham (6/2/2015)

    Ed Wagner (6/2/2015)

    cunningham (6/2/2015)

    Ed Wagner (6/2/2015)

    crookj (6/2/2015)

    Eirikur Eiriksson (6/1/2015)

    Revenant (6/1/2015)

    TomThomson (6/1/2015)

    DonlSimpson (6/1/2015)

    Sprint

    Borland

    Delphi[/quoteZeus

    Mercury

    Saturn

    Megadrive

    Sega (had to look that one up)

    yeah that was it's name...

    June 2, 2015 at 1:05 pm

    #1802414

  • RE: Today's Random Word!

    Ed Wagner (6/2/2015)

    cunningham (6/2/2015)

    Ed Wagner (6/2/2015)

    crookj (6/2/2015)

    Eirikur Eiriksson (6/1/2015)

    Revenant (6/1/2015)

    TomThomson (6/1/2015)

    DonlSimpson (6/1/2015)

    Sprint

    Borland

    Delphi[/quoteZeus

    Mercury

    Saturn

    Megadrive

    Sega (had to look that one up)

    yeah that was it's name in Europe anyway!

    Nintendo

    June 2, 2015 at 9:52 am

    #1802347

  • RE: Are the posted questions getting worse?

    rodjkidd (6/2/2015)

    BL0B_EATER (6/2/2015)

    what does SSF mean?

    It might be Spread Sheet File, but maybe I'm missing something 😉

    Rodders...

    Or SQL Server FAIL!

    June 2, 2015 at 7:34 am

    #1802294

  • RE: Today's Random Word!

    Ed Wagner (6/2/2015)

    crookj (6/2/2015)

    Eirikur Eiriksson (6/1/2015)

    Revenant (6/1/2015)

    TomThomson (6/1/2015)

    DonlSimpson (6/1/2015)

    Sprint

    Borland

    Delphi[/quoteZeus

    Mercury

    Saturn

    Megadrive

    June 2, 2015 at 7:32 am

    #1802290

  • RE: Best option for a Reporting Server

    AlwaysOn is a good solution in this case. A really good resource can be found here. Talks through options found in earlier versions of sql and how they compare to...

    June 2, 2015 at 7:26 am

    #1802285

  • RE: Today's Random Word!

    crookj (6/2/2015)

    Eirikur Eiriksson (6/1/2015)

    Revenant (6/1/2015)

    TomThomson (6/1/2015)

    DonlSimpson (6/1/2015)

    Sprint

    Borland

    Delphi[/quoteZeus

    Mercury

    Venus

    June 2, 2015 at 7:21 am

    #1802276

  • RE: Today's Random Word!

    whereisSQL? (6/1/2015)

    Ed Wagner (6/1/2015)

    Eirikur Eiriksson (6/1/2015)

    djj (6/1/2015)

    Eirikur Eiriksson (6/1/2015)

    Ed Wagner (6/1/2015)

    cunningham (6/1/2015)

    Ed Wagner (6/1/2015)

    cunningham (6/1/2015)

    Ed Wagner (6/1/2015)

    crookj (6/1/2015)

    Ed Wagner (6/1/2015)

    Revenant (6/1/2015)

    cunningham (6/1/2015)

    TomThomson (6/1/2015)

    Ed Wagner (6/1/2015)

    Away

    A-weigh

    Anchors

    News

    Facts

    Statistics

    Lies

    politicians

    Corrupt

    FIFA

    Sport

    Version

    License

    Cost

    Increase

    Budget

    blown

    June 1, 2015 at 1:44 pm

    #1802149

Viewing 15 posts - 1 through 15 (of 180 total)