Forum Replies Created

Viewing 15 posts - 1 through 15 (of 24 total)

  • RE: Log Reader Agent Blocking

    No problem, glad to hear it got fixed.

  • RE: Log Reader Agent Blocking

    No we don't have a setup like that. We have transactional replication to 3 servers with 2 push and 1 pull subscription.

  • RE: Log Reader Agent Blocking

    We were able to resolve the issue, but I can't say for sure which one thing fixed it. What I did was remove everything including the distribution database and started...

  • RE: Cheap Fun

    We have no kids as yet. But I remember as a kid me and my friend would put on a fashion show for our parents. The 'fashion' was garbage bags....

  • RE: No, I do not provide childcare at my technology events...

    I agree with the author that we need to "teach the next generation their worth regardless of gender" because its not only women that have feelings of inferiority. It is...

  • RE: Transaction Replication Latency

    Thanks to everyone that responded for their tips and advice.

    Brucla its the article you referred me to that I had found online a short while before that really helped me....

  • RE: We Still Need Human Judgment

    blandry (6/23/2010)


    Personally, I think its worse than that...

    A few days ago I was at a convenience store picking up a few essentials. My total came to $10.47 and I...

  • RE: Bad Database Design

    @dennis Wagner-347763

    Your story was sad, but so comical in the delivery, thanks for the laugh 🙂

  • RE: Raw Materials - Recurses!

    Thank you Gonickl for these amazingly funny Raw Materials comics!

  • RE: deletion of 2 million records

    Lynn Pettis (3/20/2010)


    Paul White NZ (3/19/2010)


    Lynn Pettis (3/19/2010)


    Partitions are great, but you have to running the Enterprise Edition to use them. So, with that, are you running SQL Server...

  • RE: deletion of 2 million records

    Lynn Pettis (3/19/2010)


    Partitions are great, but you have to running the Enterprise Edition to use them. So, with that, are you running SQL Server 2005 Enterprise Edition?

    It turns out...

  • RE: simple recovery model Log truncation

    vidya_pande (3/17/2010)


    I have simple solution for you.

    Copy 5 Million records to another dummy or staging table.

    Truncate the original table.

    And then copy 5 Million rows from Dummy table to original...

  • RE: Bulk Delete

    I have a date/time column

  • RE: Bulk Delete

    I want the most recent 2million records to be retained. I'm using a timestamp to check.

  • RE: deletion of 2 million records

    I read Lynn's article and got a few ideas based on the article and discussions that were done. I like the partition idea, since it seems to be quicker and...

Viewing 15 posts - 1 through 15 (of 24 total)