Forum Replies Created

Viewing 15 posts - 2,956 through 2,970 (of 49,552 total)

  • RE: Stored Procedure throws Violation of PRIMARY KEY constraint when called concurrently whit same parameters

    Y.B. (6/13/2016)

    Do you have any examples/articles you can point me to so I can check it out

    You mean other than the one I linked in my first post...

    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

    June 13, 2016 at 8:36 am

    #1884675

  • RE: Stored Procedure throws Violation of PRIMARY KEY constraint when called concurrently whit same parameters

    Y.B. (6/13/2016)

    Also Phil is right...better to make use of a MERGE here anyway.

    I disagree MERGE is NOT atomic (it should be, it isn't) and hence both it and the 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

    June 13, 2016 at 8:24 am

    #1884667

  • RE: Are the posted questions getting worse?

    Beatrix Kiddo (6/13/2016)

    (e.g. Gail's waits one clashes with Hugo's query optimizer one).

    I know, and I was looking forward to that session of Hugo'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

    June 13, 2016 at 8:18 am

    #1884665

  • RE: 13:1:78484916 suspended PAGEIOLATCH_EX

    gxdatareal (6/13/2016)

    the problem remain . any help ????

    Maybe if you answered my question.

    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

    June 13, 2016 at 8:17 am

    #1884664

  • RE: Stored Procedure throws Violation of PRIMARY KEY constraint when called concurrently whit same parameters

    Y.B. (6/13/2016)

    Maybe something like this would be better suited...

    IF EXISTS (SELECT 1 FROM SomeTable WHERE ID = @id)

    UPDATE SomeTable SET SomeText = @SomeText

    ELSE

    INSERT INTO SomeTable VALUES (@ID, @SomeText)

    Not atomic, 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

    June 13, 2016 at 8:10 am

    #1884659

  • RE: 13:1:78484916 suspended PAGEIOLATCH_EX

    Page IO Latch is a wait for the page to be read in to memory. Is it spending all the time waiting for that page, or are the waits across...

    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

    June 13, 2016 at 3:57 am

    #1884583

  • RE: Are the posted questions getting worse?

    Anyone coming to InsideSQL tomorrow?

    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

    June 13, 2016 at 3:35 am

    #1884577

  • RE: DBA career advice

    MikeS. (6/10/2016)

    Trying to report off of tables that are constantly being backfilled with millions and millions of records of credit card information just doesn't work without the nolock, otherwise you'll...

    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

    June 12, 2016 at 6:20 am

    #1884526

  • RE: Find the long running query and kill it

    Chitown (6/9/2016)

    I just can't seem to educate users who runs this long query. Even though they pull unnecessary data, they just don't seem to understand. This is my last...

    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

    June 10, 2016 at 4:08 am

    #1884329

  • RE: Working abroad - From South Africa

    Then the first thing you need to do is review the immigration laws of that country you want to move to, what is required to get a work permit there,...

    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

    June 10, 2016 at 3:58 am

    #1884323

  • RE: Find the long running query and kill it

    Why not educate the users so that they write good queries, rather than annoying them by killing their sessions?

    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

    June 9, 2016 at 1:01 pm

    #1884217

  • RE: Find the long running query and kill it

    I foresee failed backups and other maintenance tasks in your future, possibly heavier server load as reports are run again and again as they keep failing, and irate users. Possibly...

    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

    June 9, 2016 at 12:11 pm

    #1884202

  • RE: how testing works in real time environment

    Could you be a little more 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

    June 9, 2016 at 11:26 am

    #1884176

  • RE: sql server still consuming memory even after setting max server setting

    No. There's the OS as well which uses memory. Plus whatever else is running on the server. If you've installed services you don't need like SSAS, those will be running...

    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

    June 9, 2016 at 8:45 am

    #1884123

  • RE: sql server still consuming memory even after setting max server setting

    ZZartin (6/9/2016)

    Don't you have to restart the SQL Service for the new max memory setting to take affect?

    You don't.

    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

    June 9, 2016 at 8:03 am

    #1884107

Viewing 15 posts - 2,956 through 2,970 (of 49,552 total)