Forum Replies Created

Viewing 15 posts - 1,006 through 1,020 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    jasona.work - Wednesday, August 2, 2017 6:25 AM

    And now, something just for Grant, because of his comment over here: https://www.sqlservercentral.com/Forums/FindPost1889937.aspx  
    I...

    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 2, 2017 at 6:38 am

    #1953757

  • RE: Are these both same? Begin Tran & Begin Try

    curious_sqldba - Tuesday, August 1, 2017 4:54 PM

     Which one is better in your implementations.

    Neither. They're both inadequate for your requirement, 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

    August 2, 2017 at 6:18 am

    #1953754

  • RE: Should I Re-design table?

    Oh for.....
    PICTURES ARE NOT USEFUL!!!!!!!!!!!!

    If that table is partitioned, it must have a partition function (that's what makes it partitioned). If it's not partitioned, then there can'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

    August 2, 2017 at 2:36 am

    #1953713

  • RE: Should I Re-design table?

    You have no primary keys, no foreign keys on any of these tables?

    Is TBMESSAGEREDUCESENT partitioned? If so, what's the partition function and partition column?

    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 2, 2017 at 1:59 am

    #1953709

  • RE: Capture Record count and Time elapsed through SQL Server Stored Procedure

    Abhishek-385339 - Tuesday, August 1, 2017 10:15 PM

    GilaMonster - Tuesday, August 1, 2017 5:34 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

    August 2, 2017 at 1:48 am

    #1953706

  • RE: Should I Re-design table?

    Wow, like blood from a stone here.

    Ok, we now have 3 table definitions (no indexes, no constraints), the procedure and the deadlock graph.
    Can we maybe get 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

    August 2, 2017 at 1:45 am

    #1953705

  • RE: Are the posted questions getting worse?

    I think a small black hole might improve the system that Grant's ranting about.

    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 1, 2017 at 6:41 am

    #1953569

  • RE: Database in Recovery Pending State

    Please post your question in a new thread and include relevant errorlog entries and error messages.

    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 1, 2017 at 6:22 am

    #1953562

  • RE: Should I Re-design table?

    chonlatis.je - Tuesday, August 1, 2017 5:41 AM

    GilaMonster - Tuesday, August 1, 2017 5:03 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

    August 1, 2017 at 6:21 am

    #1953561

  • RE: Capture Record count and Time elapsed through SQL Server Stored Procedure

    Grant Fritchey - Tuesday, August 1, 2017 5:11 AM

    I don't think the precise thing you're looking for is possible.

    Seconded.

    Closest thing to this...

    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 1, 2017 at 5:34 am

    #1953549

  • RE: Should I Re-design table?

    And the rest of the stuff?

    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 1, 2017 at 5:03 am

    #1953540

  • RE: Should I Re-design table?

    chonlatis.je - Tuesday, August 1, 2017 1:40 AM

    GilaMonster - Tuesday, August 1, 2017 1:35 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

    August 1, 2017 at 3:56 am

    #1953530

  • RE: Should I Re-design table?

    Once more with feeling...

    GilaMonster - Monday, July 31, 2017 5:32 AM

    A picture's not very useful.

    Save the deadlock graph as a .xdl...

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

    #1953513

  • RE: Should I Re-design table?

    Grant Fritchey - Monday, July 31, 2017 7:59 AM

    My advice, get in a pro. You have a lot of big problems going...

    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

    July 31, 2017 at 8:04 am

    #1953378

  • RE: Should I Re-design table?

    GilaMonster - Monday, July 31, 2017 5:32 AM

    A picture's not very useful.

    First, I can't run a picture to create the table...

    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

    July 31, 2017 at 7:17 am

    #1953368

Viewing 15 posts - 1,006 through 1,020 (of 49,552 total)