Endorsed by Curators:
Topic: The SQL Server Transaction Log for developers
Abstract:SQL Server tracks all changes to a database's data and schema in the transaction log. This makes it the most important file in any database. Understanding transaction log architecture andbehaviorwill help you develop code that will maximize performance and minimize resource consumption. Join me to learn about transaction logarchitecture,batching transactions, rollback activity, and the effect these things can have on performance.
Frank Gill is a Senior Systems Analyst With 18 years of IT experience, the first 8 as a mainframe programmer, he has developed a love of all things internal. When not administering databases or geeking out on internals, Frank volunteers at the Art Institute of Chicago and reads voraciously.