Forum Replies Created

Viewing 15 posts - 91 through 105 (of 49,552 total)

  • RE: WHERE condition being ignored

    Aside from needing brackets, you might also want to read this:
    https://sqlinthewild.co.za/index.php/2018/03/13/revisiting-catch-all-queries/

    That query's going to perform very badly.

    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

    October 13, 2018 at 11:49 am

    #2009498

  • RE: Are the posted questions getting worse?

    Jeff Moden - Saturday, October 13, 2018 10:15 AM

    Jeff Moden - Saturday, October 13, 2018 9:42 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

    October 13, 2018 at 11:43 am

    #2009496

  • RE: Are the posted questions getting worse?

    Awesome timing. I'm busy updating the training for my grads next year and was looking for some quick exercises I could give them as a break from lectures. 'What's wrong...

    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

    October 13, 2018 at 10:07 am

    #2009486

  • RE: What's wrong with my table?

    Complete lack of normalisation, several questionable data types, lots of names that don't tell me anything (what is dtmDate?), no naming standard making this look like it was 'designed' by...

    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

    October 13, 2018 at 9:57 am

    #2009484

  • RE: MAXDOP ,Server Core & SELECT

    MAXDOP 2 limits the query to 2 *running* threads, as does a 2-core server. Why are you worried about the number of non-executing threads?

    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

    October 12, 2018 at 1:31 am

    #2009294

  • RE: Swamped server - fixed through maxdop change from 0 to 1

    Oh, no, that's not a good setting. You've just disabled parallalism server-wide and forced all queries to run single threaded. Having your CPU at 20% is not a good thing,...

    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

    October 12, 2018 at 1:28 am

    #2009293

  • RE: Difference between two join method

    crmitchell - Wednesday, October 10, 2018 8:06 AM

    I tend to prefer keeping join criteria separate from filtering criteria so would generally go...

    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

    October 10, 2018 at 1:06 pm

    #2008928

  • RE: Difference between two join method

    The second one is harder to read and takes more typing, and that's about all.

    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

    October 9, 2018 at 7:50 am

    #2008679

  • RE: MEMORY SETTINGs for SQL Server

    Min at 0 unless you have a really good reason. Max, server's physical memory - what anything else on the server needs - reservation for the OS.

    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

    October 9, 2018 at 7:45 am

    #2008678

  • RE: optimize sql stored proc for better performance

    Oh there is so much that can be optimised in there.

    Table variables - slow, avoid, use temp tables instead.
    Multiple execution paths - erratic performance, avoid
    Multi-statement table-valued...

    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

    October 9, 2018 at 3:39 am

    #2008631

  • RE: Help to find the bottleneck

    Bit outdated, but still usable.
    https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server-part-1/
    https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server-part-2/

    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

    October 9, 2018 at 3:13 am

    #2008628

  • RE: SQL 2008 corruption

    Lj Burrows - Thursday, September 27, 2018 11:07 PM

    DBCC CECKDB can't repair these errors. You have got no choice...

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

    #2007342

  • RE: What does your backup process look like?

    You still want to run CheckDB on the secondaries.

    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

    August 14, 2018 at 4:30 am

    #2001599

  • RE: What does your backup process look like?

    Mike Scalise - Monday, August 13, 2018 7:00 AM

     -- is there a good reason NOT to perform all of these tasks on...

    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

    August 13, 2018 at 10:08 am

    #2001513

  • RE: Adding Indexes to Tables

    https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server-part-1/
    https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server-part-2/

    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

    August 6, 2018 at 7:37 pm

    #2000533

Viewing 15 posts - 91 through 105 (of 49,552 total)