Forum Replies Created

Viewing 15 posts - 5,191 through 5,205 (of 49,552 total)

  • RE: A stored procedure that usually runs fast ran for a long time yesterday

    That's parallelism waits, not actual blocking

    Have you looked at the execution plans?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 24, 2015 at 4:57 am

    #1814688

  • RE: Unique counts

    Could you please expand the sample data to show when an ID will return more than 1 for a year?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 24, 2015 at 3:25 am

    #1814672

  • RE: A stored procedure that usually runs fast ran for a long time yesterday

    The wait durations in the screenshot are all around 15ms, so probably not significant (timeout is 30 seconds). They're also from all different processes and you haven't indicated which process...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 24, 2015 at 3:16 am

    #1814670

  • RE: Are the posted questions getting worse?

    rodjkidd (7/23/2015)

    Gail, well done. Seriously impressive.

    I hope you are celebrating this weekend?

    Taking myself and a good book to an expensive Chinese restaurant tonight. Yes, that's a celebration.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 24, 2015 at 2:57 am

    #1814665

  • RE: Are the posted questions getting worse?

    I don't know how things are done in the US, but here 75% is the threshold for a degree to be awarded "With Distinction"

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 23, 2015 at 11:19 am

    #1814472

  • RE: Recycling sql server memory daily

    No, because like the buffer pool it's not per-process. You should be able to use the memory clerks or other memory DMV to identify what area is using a lot...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 23, 2015 at 10:37 am

    #1814455

  • RE: Query Execution plan too long

    Don't try reading the XML plan. Use the graphical one.

    You won't find CPU time in the plan. You'll find costs, but they aren't times and can't be used to do...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 23, 2015 at 10:14 am

    #1814449

  • RE: Recycling sql server memory daily

    muthyala_51 (7/23/2015)

    So do you suggest to run the above mentioned job to reduce the max server memory on the server daily ?

    No. Absolutely not.

    There is a Linked server openrowset query...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 23, 2015 at 9:51 am

    #1814442

  • RE: Are the posted questions getting worse?

    !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 23, 2015 at 9:45 am

    #1814439

  • RE: Query Help

    sqlnaive (7/23/2015)

    colA4 = 'case'

    and colA4 = 'ifelse'

    I'm going to assume there's a mistake here, as a single column can't be equal to two values at the same time.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 23, 2015 at 7:50 am

    #1814373

  • RE: Query Execution plan too long

    Luis Cazares (7/23/2015)

    Remember that GUI plans are read right to left.

    Left-to-right to see the control flow.

    Right-to-left to see the data flow.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 23, 2015 at 7:45 am

    #1814371

  • RE: Query Help

    John Mitchell-245523 (7/23/2015)

    Something like this?

    create view vw_main

    as

    select colA1, colA2, colA3, colA4, colA5, colB2

    from tableA A inner join tableB B

    on (A.ColA1 = ColB1 AND colA4 = 'case') OR colA4 = 'ifelse'

    John

    Careful,...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 23, 2015 at 7:39 am

    #1814368

  • RE: Query Help

    Union all if there's no overlap or if duplicates are OK. Union if you want to eliminate duplicates.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 23, 2015 at 7:35 am

    #1814365

  • RE: Recycling sql server memory daily

    Queries don't use much memory. The SQLBufferPool clerk is the data cache, the plan cache and a few other caches. It should be the highest memory consumer as that's the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 23, 2015 at 7:33 am

    #1814363

  • RE: String Query Help

    There are ways to do it, but they're complex, harder to read and usually perform badly, hence why I'm recommending you use two statements. Production code isn't where you show...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 23, 2015 at 6:54 am

    #1814352

Viewing 15 posts - 5,191 through 5,205 (of 49,552 total)