Forum Replies Created

Viewing 15 posts - 7,876 through 7,890 (of 49,552 total)

  • RE: Reduce locking for Insert statement?

    sqlsurfing (9/10/2014)

    I think i'll focus on working w/developer on any tweaks first on that blocking sproc first.

    Good idea. Can't see anything in the code you posted...

    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 11, 2014 at 12:06 am

    #1744636

  • RE: Performance cost for shrinking a log file

    Sean Perkins (9/10/2014)

    So, the process of shrinking log files (or data files) won't cause a ridiculous performance hit during production hours?

    Shrinking data files certainly will.

    Shrinking log shouldn't, but do 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

    September 10, 2014 at 3:03 pm

    #1744598

  • RE: Performance cost for shrinking a log file

    Steps:

    1. Backup the TLOG

    2. Change DB from Full to Simple

    3. Change the initial size of the TLOG to something much smaller

    4. Perform the log shrink

    5. Change from Simple to Full

    6....

    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 10, 2014 at 2:52 pm

    #1744596

  • RE: Thanks to Gail and Grant

    And thank you. The 24hop session was better received than I'd expected, seeing as it's fairly dry internals all the way through.

    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 10, 2014 at 1:51 pm

    #1744581

  • RE: Thanks to Gail and Grant

    Grant Fritchey (9/10/2014)

    I'd love to present with Gail again, regardless of the harm we would inflict on others. We had way too much fun.

    Shall we try for Bits next year?

    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 10, 2014 at 1:50 pm

    #1744579

  • RE: Changing recovery model

    GilaMonster (4/11/2011)

    Please post new questions in a new thread. Thank 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

    September 10, 2014 at 1:42 pm

    #1744572

  • RE: Thanks to Gail and Grant

    sqldriver (9/10/2014)

    Has anyone seen them together at the same time? They sound awfully alike.

    Yes, I assure you many, many people have seen us both at the same time. Including an...

    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 10, 2014 at 1:39 pm

    #1744571

  • RE: Are the posted questions getting worse?

    Waaaaay out of his depth... http://www.sqlservercentral.com/Forums/Topic1612186-357-1.aspx

    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 10, 2014 at 1:33 pm

    #1744567

  • RE: Log Shipping destination stuck on "restoring..."

    cafescott (9/10/2014)

    I am trying to get the log shipping going so that we can copy a production database several times a day for the purpose of doing reporting on 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

    September 10, 2014 at 1:28 pm

    #1744565

  • RE: Log Shipping destination stuck on "restoring..."

    Because if you recover the DB (bring it online), thereby removing the restoring status as you asked, you won't be able to restore more log backups and hence your log...

    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 10, 2014 at 11:37 am

    #1744534

  • RE: Rebuild index and update statistics.

    dinsab11 (9/10/2014)

    @GilaMonster: My questin was what's the best way to check when statistics were update last time on A DATABASE (all table).

    Query sys.stats and use the STATS_DATE function. 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

    September 10, 2014 at 11:32 am

    #1744531

  • RE: Are the posted questions getting worse?

    Sean Lange (9/10/2014)

    Steve Jones - SSC Editor (9/10/2014)

    WayneS (9/10/2014)

    Sean Lange (9/9/2014)

    I think I should be able to make it for the afternoon sessions. The last game should be done 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

    September 10, 2014 at 10:42 am

    #1744506

  • RE: Rebuild index and update statistics.

    er.mayankshukla (9/10/2014)

    I guess some heavy updates might be the reason for that

    Might be. Or might not. I prefer not to assume such things when I have no idea.

    Even if heavy...

    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 10, 2014 at 10:38 am

    #1744503

  • RE: Rebuild index and update statistics.

    er.mayankshukla (9/10/2014)

    I don't think u need to update column stats as well. If your rebuilds and updates have affected enough rows in table I.e. the threshold value for triggering auto...

    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 10, 2014 at 10:05 am

    #1744488

  • RE: Rebuild index and update statistics.

    Check them for what?

    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 10, 2014 at 10:04 am

    #1744487

Viewing 15 posts - 7,876 through 7,890 (of 49,552 total)