Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Basic Auditing - SQL School Video Expand / Collapse
Author
Message
Posted Monday, March 9, 2009 3:46 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Yesterday @ 2:51 PM
Points: 6,790, Visits: 1,902
Comments posted to this topic are about the item Basic Auditing - SQL School Video

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #672014
Posted Tuesday, March 10, 2009 7:52 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 6:34 AM
Points: 554, Visits: 1,200
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!
Post #672435
Posted Thursday, March 12, 2009 5:13 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, January 2, 2013 12:15 PM
Points: 1,443, Visits: 711
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
Post #674078
Posted Wednesday, March 25, 2009 7:39 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, May 13, 2014 2:31 PM
Points: 76, Visits: 152
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
Post #683293
Posted Friday, January 7, 2011 4:19 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, January 7, 2011 4:32 AM
Points: 1, Visits: 2
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.


MCSE exam | PMP certification
Post #1044289
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse