Forum Replies Created

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

  • RE: Data Distribution - Part 2

    mishaluba (10/15/2010)


    Thank you for the article, Leo! I found it interesting. A couple of questions please. Could you clarify what is behind this line:

    raiserror (51080,...

  • RE: Data Distribution - Part 2

    It is always load zone for the data. Article is not suggested to enter data directly in trigger from server to server. It telling that there is job on each...

  • RE: Data Distribution - Part 2

    alen teplitsky (10/14/2010)


    i think that if you're adding triggers to try to keep track of every single change you have problems, security problems. it's a huge performance hit to have...

  • RE: Data Distribution - Part 2

    clementhuge (10/14/2010)


    Hello,

    The article is interesting but I believe we have to avoid triggers at all price for performance and maintainability reason. I usually put a timestamp or datetime column like...

  • RE: Log shipping and A Control Mechanism

    Ignacio A. Salom Rangel (7/27/2010)


    Thank you for your response Leo. I don't think it is unfurtunate that I have to implement the jobs myself, on the contrary I'm quite excited...

  • RE: Data Distribution - Part 1

    Steve Jones - Editor (7/26/2010)


    I'm not sure what happened, but I have added back the last code snippet and final para.

    Thanks, Steve.

  • RE: Data Distribution - Part 1

    Thanks, now it has the sence.

  • RE: Data Distribution - Part 1

    If text will not be edited with missed part, then I will add the missing part in comment tomorrow.

  • RE: Data Distribution - Part 1

    Phil Factor (7/26/2010)


    I'm not clear to me whether you are suggesting that this approach (restore followed by a rename) is a good way of updating the data...

  • RE: Log shipping and A Control Mechanism

    Ignacio A. Salom Rangel (7/24/2010)


    Great piece Leo. I think for DBA's with less experience (Like myself) it would have been nice if the article was little more detailed, but then...

  • RE: Log shipping and A Control Mechanism

    amarokmusic (7/1/2010)


    Hi,

    Very interesting article. However, I wasn't sure if the reason for architechting this solution was to facilitate log shipping replication for SQL 2000 and below, or as a way...

  • RE: coalesce and nullif

    vk-kirov (6/23/2010)


    Nice question.

    OFF

    I would like thanks my coorker...

    What does the word 'coorker' mean? Is it a typo and needs to be 'coworker'?

    It means coworker. It was typo

  • RE: Twenty tips to write a good stored procedure

    jonwolds (8/10/2009)


    Some points in this article no longer apply, some are mis-leading and some are just incorrect. Please read with caution.

    Absolutely agreed. Very dangerous article espesially for newbees. Better not...

  • RE: The New Reality of an Audit Trail

    David McKinney (7/9/2009)


    It's early in the morning (pre-coffee) but where do you construct the xml?

    XML is constructed in application framework. Our application architects made object's property as auditable and, if...

  • RE: The New Reality of an Audit Trail

    Michael Whiteley (7/8/2009)


    If only using SQL 2008 I would use Change Data Capture it does it all for you.

    Unfortunately, Change data capture is available only on the...

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