Basic Auditing - SQL School Video

  • Comments posted to this topic are about the item Basic Auditing - SQL School Video

  • I'm curious as to how the performance impact and usability of the trigger pattern is in comparison to the StartDate and EndDate column pattern where the most recent row has an EndDate of NULL. Then you use an indexed view over the table with a "where EndDate IS NULL" clause.

    Anyone choose between the two and why?

    I'm inclined to use the StartDate and EndDate pattern when tracking changes across all columns.

    *** Edited for appreciation comment ***

    Thank you for the video, well done!

  • Andy,

    Well done! The pattern you used is similar to patterns I've used through the years, would like to see if there is a different implementation in SQL 2008? Maybe use CDC instead?

    I guess CDC would have less of a performance impact than the trigger, and would be a simpler implementation?

    Mark

  • I would like to see how this can be implemented in SQL 2008 - would you recommend using same method you shared or using the newly release feature of change control?

    Farhan F. Sabzaali
    PMP, MCP, MCDBA, MCSA, MCSE

  • Hi guys,

    I’ve tried to implement on SQL 2008 too, but it’s not happening. So I see where you are coming from Farhan. Andy thanks for the video, very helpful. One of the methods I found tricky is How do you track changes to data in your database. Could this be something to do with the design in my solution from the start? I was advised to apply some variety of direct access methods, but found myself going in circles. Can anyone recommend any books; I’m currently looking into one by Nigel Rivett. Doing the system administration exam (70-228) was a mission itself, by the way, has anyone in here ever experienced some anomalies with their PMP after updating SQL, what else can you do other than rerunning pmp401.exe or something??

    Thanks in advance for your response.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply