Forum Replies Created

Viewing 15 posts - 11,341 through 11,355 (of 39,793 total)

  • RE: Offloading backups to AlwaysOn secondary replicas - any issues with copy-only full backups?

    dave-L (1/28/2014)


    It looks like this is, in fact, the case; Backing up the transaction log on the read-only secondary replica truncates the transaction log on the primary.

    It's supposed to, otherwise...

  • RE: Servicing SQL Server in the Future

    Good points, Aaron, and I agree with you that I want CUs and quality has been good. However the caveats about support, and the fact that bi-monthly is quite fast,...

  • RE: Are the posted questions getting worse?

    Great quote of the day:

    ==

    GilaMonster (1/16/2014)

    That risk is why the log backup interval should be less than the allowable data loss for the system.

    ==

    I need to remember to use...

  • RE: Database Restore

    GilaMonster (1/16/2014)


    That risk is why the log backup interval should be less than the allowable data loss for the system.

    Best quote I've seen in awhile and very true.

  • RE: Common Checks

    phegedusich (1/24/2014)


    "While we considered changing to a bigint, this was a third party product and they did not want to allow us to alter the schema."

    There's your problem. Perhaps testing...

  • RE: Pros and Cons of a Central Management Server

    Jeff Moden (1/28/2014)


    Thank you both. That's more inline of what I thought CMS should be for. What I've found is that a lot of people have written PoSH...

  • RE: Pros and Cons of a Central Management Server

    I believe you can export the CMS settings and save them. However, as Roy mentioned, not a big deal. It's just a place you connect that sends your queries to...

  • RE: Servicing SQL Server in the Future

    If you want service packs, let Microsoft know. I think they're on the fence right now, but it takes some voices voting to get them to continue with SPs.

    Vote on...

  • RE: DBCC CHECKDB Questions on general practice

    I try to run daily (We do at SSC), but weekly at the latest. Once you automate it, it's not bad.

    There are people that run monthly, or less frequently (including...

  • RE: Talking baseball

    The Yankees used to do better, build better farm systems, and grow players, but they've gotten out of the habit and are too afraid of not having big names.

    I hate...

  • RE: It's not the platform

    Never had SQL run for 18 years, but I have had it run for 2. The problem I've most often seen with long running SQL stuff is Windows. Too many...

  • RE: Replication

    Hugo Kornelis (1/24/2014)


    L' Eomot Inversé (1/24/2014)


    Yes, but how is release of the log records prevented?

    My guess is that the information on that page you used is incorrect. But I have...

  • RE: Management at Scale

    djackson 22568 (1/27/2014)


    Steve Jones - SSC Editor (1/25/2014)


    Comments posted to this topic are about the item <A HREF="/articles/Editorial/106276/">Management at Scale</A>

    Steve, which came first, the chicken or the egg?

    I recognize that...

  • RE: Management at Scale

    paul.knibbs (1/27/2014)


    What does "provide more value than they cost" mean? Sounds like you want workers to do more work for the same money, but I'm sure that's not what you...

  • RE: Better Writing

    I'm with you, Dale. Convention has "who" listed as more likely, but both apply:

    http://english.stackexchange.com/questions/11204/how-to-use-who-vs-that

Viewing 15 posts - 11,341 through 11,355 (of 39,793 total)