Forum Replies Created

Viewing 15 posts - 1,561 through 1,575 (of 49,552 total)

  • RE: Access is denied when I try to test localhost>mysql -u root -p

    This site's for Microsoft SQL Server, and as such you'll probably find better help with this at a dedicated MySQL site.

    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 18, 2017 at 2:01 am

    #1938453

  • RE: set xact_abort on required if entire proc in explicit transaction?

    pisorsisaac - Monday, April 17, 2017 10:06 AM

    I have an entire procedure wrapped in an try/catch statement.  commit tran is placed at...

    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 17, 2017 at 4:32 pm

    #1938413

  • RE: Deadlocks on Clustered Index

    First time I've ever seen a single-resource deadlock. Interesting.

    This can be fixed if you can change the code for the UPDATE statement. Can you?

    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 17, 2017 at 10:08 am

    #1938328

  • RE: Override Columns in Insert and Update

    In your update trigger you can use IF UPDATED(ColumnName) to check whether something other than the created and updated dates were updated, and only proceed with the trigger if other...

    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 16, 2017 at 4:02 pm

    #1938268

  • RE: Deadlocks on Clustered Index

    Lynn Pettis - Friday, April 14, 2017 2:56 PM

    Just a dumb question, but could this be a result of the Branch...

    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 15, 2017 at 6:55 am

    #1938252

  • RE: Deadlocks on Clustered Index

    Can you please post the CREATE TABLE for SalBranch, and the CREATE INDEX statement for each index on it.

    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 14, 2017 at 1:45 pm

    #1938218

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor - Friday, April 14, 2017 1:21 PM

    Is it me, or is the new Star Wars trailer just...

    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 14, 2017 at 1:37 pm

    #1938217

  • RE: Table size and indexes

    My answer was a bit flippant, but the point is there's no minimum row count to have before creating an index. What the index is created on (and, even 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

    April 14, 2017 at 3:43 am

    #1938150

  • RE: Part of the code is missing in SP

    GO is not a T-SQL command. It's a Management Studio batch terminator. When SSMS (and several other clients) encounters a GO, it sends the text up to that point to...

    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 14, 2017 at 3:41 am

    #1938149

  • RE: Deadlocks on Clustered Index

    Not a picture of the deadlock graph. The graph itself, either saved as a file (.xdl) or paste the text of it.

    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 14, 2017 at 3:39 am

    #1938148

  • RE: Deadlocks on Clustered Index

    Can you post the deadlock graph?

    A deadlock has to be two sessions  (or more) and two resources (or more), so there's something else involved.

    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 13, 2017 at 11:04 am

    #1938103

  • RE: Upgrading from sql server 2012 to 2016

    dudekula.kareemulla - Thursday, April 13, 2017 12:41 AM

    So due to that reason i am looking for is there any particular link...

    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 13, 2017 at 1:33 am

    #1937968

  • RE: Copy-Only backups in backup chain.

    And an old blog post discussing the subject (also read the posts that it links to): http://sqlinthewild.co.za/index.php/2011/03/08/full-backups-the-log-chain-and-the-copy_only-option/

    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 12, 2017 at 2:29 pm

    #1937940

  • RE: SQL code

    Hit google and look for 'dynamic pivot', that should be enough to get you started.

    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 12, 2017 at 2:24 pm

    #1937939

  • RE: Are the posted questions getting worse?

    BrainDonor - Wednesday, April 12, 2017 6:08 AM

    GilaMonster - Wednesday, April 12, 2017 5:53 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

    April 12, 2017 at 2:22 pm

    #1937937

Viewing 15 posts - 1,561 through 1,575 (of 49,552 total)