Forum Replies Created

Viewing 15 posts - 1,591 through 1,605 (of 49,552 total)

  • RE: Compilation lock and blocking

    Robin35 - Monday, April 3, 2017 3:00 PM

    GilaMonster - Monday, April 3, 2017 2:41 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

    April 4, 2017 at 3:24 am

    #1936468

  • RE: Query on locks taken in a Deadlock

    Shameless self-promotion: https://www.simple-talk.com/sql/performance/sql-server-deadlocks-by-example/

    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

    April 4, 2017 at 3:22 am

    #1936467

  • RE: Can you reorganize this SQL stmt please ?

    mw112009 - Monday, April 3, 2017 4:13 PM

    Lynn Pettis - Monday, April 3, 2017 12:27 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

    April 4, 2017 at 3:21 am

    #1936465

  • RE: Query Performance Execution Plan Cost vs Execution Time

    Costs != times

    Costs are unitless values that are solely used for the Query Optimiser to decide what plans are cheaper than others. They're not a measure of CPU...

    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

    April 4, 2017 at 3:18 am

    #1936464

  • RE: Compilation lock and blocking

    Yup, a design like that will cause recompilations on every execution, and if it's executed frequently will cause compile locks (only one session can be compiling a query at 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

    April 3, 2017 at 2:41 pm

    #1936422

  • RE: I'm "working from home"

    Almost every time I try having a video conference session from home, my cat joins in. Usually by jumping from the windowsill onto my desk, so the other person gets...

    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

    April 3, 2017 at 7:53 am

    #1936288

  • RE: What do you do to relax after work?

    Roleplaying (Running a Star Wars Saga game, running an Exalted game, playing in a 5th ed D&D game)
    Playing board games
    Playing computer games
    Reading

    I 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

    April 3, 2017 at 3:55 am

    #1936229

  • RE: SQL Server | Architecture design -

    ranitb - Friday, March 31, 2017 5:04 PM

    I find Oracle's implementation and way Commit/Rollbacks were used to mark a transaction is better...

    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

    April 3, 2017 at 3:53 am

    #1936227

  • RE: SQL Server DBA Certification

    smatu - Wednesday, March 29, 2017 3:34 PM

    I want to become a certified DBA,

    Why? What's your goal?

    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

    April 3, 2017 at 3:46 am

    #1936226

  • RE: Compilation lock and blocking

    The naming is unlikely to be causing the lock. The sp_ prefix means that SQL looks in master and the resource DB before the user DB for the object, that's...

    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

    April 3, 2017 at 3:42 am

    #1936225

  • RE: Query on locks taken in a Deadlock

    Gavin Whittaker - Monday, April 3, 2017 2:52 AM

     Is it just a question of setting up a trace to get exactly what's...

    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

    April 3, 2017 at 3:06 am

    #1936221

  • RE: 2016 Cluster Questions For Always On but also with other services

    Perry Whittle - Friday, March 31, 2017 11:07 AM

    GilaMonster - Wednesday, March 29, 2017 2:56 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

    March 31, 2017 at 11:55 am

    #1936048

  • RE: Statistics with NORECOMPUTE

    alex.sqldba - Thursday, March 30, 2017 12:19 PM

    Hmm, so what is a high key considered? Does it depend on the index...

    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

    March 30, 2017 at 1:50 pm

    #1935838

  • RE: Are the posted questions getting worse?

    Sean Lange - Thursday, March 30, 2017 10:00 AM

    Many thanks Gail and her blog about parameter sniffing. I can't count the number...

    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

    March 30, 2017 at 11:40 am

    #1935792

  • RE: Statistics with NORECOMPUTE

    The density in the stats header is useless, ignore it.

    You can't, by looking at the histogram, tell whether your stats are good or not.
    eq_rows is 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

    March 30, 2017 at 6:35 am

    #1935691

Viewing 15 posts - 1,591 through 1,605 (of 49,552 total)