Forum Replies Created

Viewing 15 posts - 30,136 through 30,150 (of 49,552 total)

  • RE: Race to post 1,000,000

    Craig Farrell (10/6/2010)

    How can you sleep with that just LOVELY project you're on? You'll still be awake. Bleery eyed, grumpy, and ready to bean your PM with...

    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

    October 6, 2010 at 3:05 pm

    #1233103

  • RE: Race to post 1,000,000

    Steve Jones - SSC Editor (10/6/2010)

    I suspect it will be tonight now.

    Almost certainly. Gonna be all over by tomorrow morning and it's almost bed time for me (approaching midnight).

    No...

    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

    October 6, 2010 at 2:59 pm

    #1233089

  • RE: Join Problem

    Then post the estimated plan. Is that what you posted earlier?

    We prefer the actual plans, because there's far more info in there, but if the query won't finish the estimated...

    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

    October 6, 2010 at 2:53 pm

    #1233077

  • RE: Managing Transaction Logs

    RichardDouglas (10/6/2010)

    oh god, great point Gail, you might want to check your index fragmentation too. Paul Randall did a great demo on how shrinking your files causes fragmentation.

    That's only 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

    October 6, 2010 at 2:51 pm

    #1233074

  • RE: Are the posted questions getting worse?

    Tom.Thomson (10/6/2010)

    No, just that you have to be. But being female you have an automatic self-renewing "Just because I have to be doesn't mean I am" card. :hehe:

    Um......

    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

    October 6, 2010 at 2:50 pm

    #1233073

  • RE: Managing Transaction Logs

    RichardDouglas (10/6/2010)

    If you want to add more weight to it talk about management of virtual log files. Google/Bing "VLF" and "SQLSkills". Kimberley and Paul have some great blogs 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

    October 6, 2010 at 2:40 pm

    #1233061

  • RE: Are the posted questions getting worse?

    Shawn Melton (10/6/2010)

    I have to ask you Gail (and others that frequent this forum) how the heck do yall move between answering post so quickly? Do you just have tons...

    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

    October 6, 2010 at 2:37 pm

    #1233058

  • RE: Are the posted questions getting worse?

    Craig Farrell (10/6/2010)

    Until recently I had no idea how many people screwed up full vs. bulk vs. simple...

    I wonder how many could explain briefly the differences between the three recovery...

    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

    October 6, 2010 at 2:27 pm

    #1233045

  • RE: Managing Transaction Logs

    MostInterestingMan (10/6/2010)

    Understood. If we were about to move to simple recovery model will the current backup strategy hold? Weekly Full and nightly Diffs.

    Yes.

    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

    October 6, 2010 at 2:21 pm

    #1233038

  • RE: Managing Transaction Logs

    MostInterestingMan (10/6/2010)

    So when the diff backups occur is the log not backup at the time as well?

    No.

    Full and diff backups contain only enough of the log to be able...

    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

    October 6, 2010 at 2:19 pm

    #1233035

  • RE: Are the posted questions getting worse?

    Is today 'Mismanage your transaction log' day?

    http://www.sqlservercentral.com/Forums/Topic999809-146-1.aspx

    3rd one so far today.

    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

    October 6, 2010 at 2:17 pm

    #1233030

  • RE: Shrink the log file size

    Derrick Smith (10/6/2010)

    Tom Goltl (10/6/2010)

    If your going to keep this in simple recovery mode I would add a step in your backup job to truncate the logfile

    Do not do 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

    October 6, 2010 at 2:13 pm

    #1233025

  • RE: Are the posted questions getting worse?

    Tom.Thomson (10/6/2010)

    Brandie Tarvin (10/6/2010)

    GilaMonster (10/6/2010)

    Does anyone think my response here was over-the-top? http://www.sqlservercentral.com/Forums/FindPost999124.aspx

    No. I find it professional and well-reasoned. It is the correct and necessary response to the question.

    I agree....

    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

    October 6, 2010 at 2:13 pm

    #1233024

  • RE: Managing Transaction Logs

    A couple of related threads from earlier today:

    http://www.sqlservercentral.com/Forums/Topic999051-360-1.aspx

    http://www.sqlservercentral.com/Forums/Topic981205-24-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

    October 6, 2010 at 2:12 pm

    #1233023

  • RE: Are the posted questions getting worse?

    Tom.Thomson (10/6/2010)

    In my experience that is the normal frustration you should expect if you have a "project manager" in the loop who is neither a devloper nor a user 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

    October 6, 2010 at 2:08 pm

    #1233016

Viewing 15 posts - 30,136 through 30,150 (of 49,552 total)