Real-Time Audit Logging System in SQL Server Implementing a real-time audit logging system in SQL Server involves capturing changes made to critical tables, such as Employees and Salaries, and ...

SQL Server transaction logs A transaction log is a sequential record of all changes made to the database while the actual data is contained in a separate file.

SQL Server, of course, keeps track of everything that affects data in a transaction log, which is periodically rolled over into backup files (at least, if you're being a conscientious DBA it is). But ...

We've got a table used to log operations that gets it's data aggregated and then all it's rows deleted nightly, which I'm trying to speed up as much as possible. I think that deleting the rows is ...

Microsoft on Thursday released Service Pack 3 (SP3) for SQL Server 2008. The new service pack arrives about one year after the release of Service Pack 2. SP3 contains a lot of fixes to the earlier ...

I would like to know how transaction log size is managed. I now know after some reading that I can checkpoint the database in order to allow dirty pages to write from ram to disk.I also know now ...