Forum Replies Created

Viewing 15 posts - 136 through 150 (of 49,552 total)

  • RE: Insert-Update Concurrency Simulator

    No load test, but I did the tests for you
    https://sqlinthewild.co.za/index.php/2018/02/27/homebuilt-sequential-columns/

    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 12, 2018 at 3:24 pm

    #1997409

  • RE: A Stairway series on Performance Tuning would be amazing!

    Steve Jones - SSC Editor - Tuesday, July 10, 2018 9:20 AM

    I could see a stairway on each topic, and maybe an...

    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 11, 2018 at 11:24 am

    #1997167

  • RE: Stored Procedure

    ScottPletcher - Monday, July 9, 2018 3:45 PM

    GilaMonster - Monday, July 9, 2018 3:19 PM

    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 9, 2018 at 3:54 pm

    #1996881

  • RE: Stored Procedure

    ScottPletcher - Monday, July 9, 2018 10:35 AM

    GilaMonster - Monday, July 9, 2018 2:58 AM

    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 9, 2018 at 3:19 pm

    #1996875

  • RE: Stored Procedure

    EXEC dbo.GetCustomerDetails @CustomerName = 'Customer name here'

    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 9, 2018 at 10:23 am

    #1996819

  • RE: how to get sum of each row and column

    That's probably easier to do in your app, wherever you display this data.

    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 9, 2018 at 7:59 am

    #1996787

  • RE: how to get sum of each row and column

    This should mostly do what you want.


    WITH Src
    AS (SELECT station_no,
        CASE WHEN TestResult = 'ok' THEN 1 END AS ok,
        ...

    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 9, 2018 at 7:30 am

    #1996780

  • RE: Database Audit

    The CREATE TABLE statements for the tables, if Access even does that. It's been years since I looked at Access to be honest.

    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 9, 2018 at 6:50 am

    #1996772

  • RE: Are the posted questions getting worse?

    Is there any way to request a thread be moved in the new forum? I used to report it and ask in the details, but the new forum doesn't have...

    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 9, 2018 at 5:28 am

    #1996755

  • RE: Database Audit

    I'll see if I can get this moved to the MS Access forum, as a trigger that is written for SQL Server won't work in Access (I can't even remember...

    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 9, 2018 at 5:27 am

    #1996754

  • RE: Database Audit

    MDB? Is that an MS Access file?

    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 9, 2018 at 4:26 am

    #1996748

  • RE: High availability solution

    doodlingdba - Monday, July 9, 2018 3:17 AM

     But i think it's fair to say that high availability means near real time data...

    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 9, 2018 at 4:20 am

    #1996746

  • RE: A Stairway series on Performance Tuning would be amazing!

    May I recommend http://www.sqlservercentral.com/articles/books/76296/, http://www.sqlservercentral.com/articles/books/94937/, http://www.sqlservercentral.com/articles/books/71564/ and http://www.sqlservercentral.com/articles/books/70486/?

    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 9, 2018 at 4:13 am

    #1996745

  • RE: Stored Procedure

    debasis.yours - Monday, July 9, 2018 2:20 AM

    Yes, actually WITH(NOLOCK) hint may return incorrect result sometimes by showing data from other uncommitted...

    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 9, 2018 at 2:58 am

    #1996736

  • RE: High availability solution

    The 'best' will be determined by your requirements, RPO, RTO among them.

    You have basic availability groups, log shipping and failover clustering as your main options on Standard Edition.

    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 8, 2018 at 1:28 pm

    #1996708

Viewing 15 posts - 136 through 150 (of 49,552 total)