Forum Replies Created

Viewing 15 posts - 766 through 780 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Lynn Pettis - Tuesday, September 19, 2017 1:11 PM

    GilaMonster - Tuesday, September 19, 2017 11:44 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

    September 19, 2017 at 1:42 pm

    #1960032

  • RE: Cancel Query Rollback

    Please note: 7 year old thread.

    A SELECT without modifications doesn't have to roll back, as there's nothing to undo. It won't stop instantly, but it doesn't rollback. If,...

    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

    September 19, 2017 at 12:02 pm

    #1960018

  • RE: SQL server Max Memory setting is not working

    John Mitchell-245523 - Tuesday, September 19, 2017 7:36 AM

    (unless you set your minimum memory higher, but you should only do that if...

    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

    September 19, 2017 at 11:57 am

    #1960017

  • RE: Why Grant User View Definitions to Database Objects?

    andrew.jones 69458 - Tuesday, September 19, 2017 9:10 AM

    I understand that it allows users to see the metadata for an object, but...

    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

    September 19, 2017 at 11:49 am

    #1960014

  • RE: Are the posted questions getting worse?

    Lynn Pettis - Tuesday, September 19, 2017 9:55 AM

    My Google-Fu is failing me.  Does anyone know where I may find information comparing...

    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

    September 19, 2017 at 11:44 am

    #1960012

  • RE: view time out

    Please note: 6 year old thread.

    And yes, changing the timeout from 30 seconds to 5 minutes may stop it timing out, but it's not fixing the problem (slow...

    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

    September 19, 2017 at 11:42 am

    #1960011

  • RE: Execution time Improvement - Knowing the problem, but not the solution

    Thom A - Monday, September 18, 2017 8:51 AM

     I'm guessing that the estimator saw that != 3 was non...

    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

    September 18, 2017 at 2:08 pm

    #1959871

  • RE: Execution time Improvement - Knowing the problem, but not the solution

    I shouldn't post when I'm exhausted. Saw the @ and brain interpreted as a parameter.

    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

    September 18, 2017 at 9:04 am

    #1959821

  • RE: Transaction Logs

    204 is not a problematic number. I wouldn't worry with that number. Several thousands is where I'd probably start to worry

    If you do want to fix it,  neither...

    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

    September 18, 2017 at 7:55 am

    #1959789

  • RE: Does sparse columns really work? or at least, how does it work?

    I probably wouldn't consider sparse without having 95%+ being null and having a good number of the columns in the table mbeing mostly null. It's a feature with a specific...

    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

    September 18, 2017 at 7:48 am

    #1959785

  • RE: Which is GOOD/BETTER out of two ways of writing a query ??

    The first has to read the Dept table once (for the join), the second has to read it twice (once for each subquery). The first is easier to read and...

    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

    September 18, 2017 at 7:41 am

    #1959780

  • RE: Are the posted questions getting worse?

    Thom A - Monday, September 18, 2017 7:12 AM

    I realise that I've not posted the table definitions, but if anyone can give...

    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

    September 18, 2017 at 7:40 am

    #1959779

  • RE: Execution time Improvement - Knowing the problem, but not the solution

    You've got a catch-all type query. They're slow (and writing the WHERE clause in a more complicated form doesn't make that any better)

    https://www.simple-talk.com/sql/t-sql-programming/how-to-confuse-the-sql-server-query-optimizer/

    WITH RECOMPILE...

    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

    September 18, 2017 at 7:40 am

    #1959778

  • RE: High Memory consuming by Database

    Please note: 4 year old thread

    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

    September 17, 2017 at 7:42 am

    #1959694

  • RE: Best way to keep users/logins/mappings syncrhronized in HAG between primary and secondary replicas?

    WebTechie - Thursday, September 14, 2017 10:41 AM

    However, the big problem is that you can't create a login and map it to a...

    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

    September 14, 2017 at 12:24 pm

    #1959485

Viewing 15 posts - 766 through 780 (of 49,552 total)