Understand the Transaction Log, Unlock Greater Throughput
There's no doubt about it, the transaction log is treated like the proverbial ginger haired step child. The poor thing does not receive much love, the transaction log however is a very essential and misunderstood part of your database. There will be a team of developers creating an absolutely awesome elegant design the likes of which have never been seen before, but the leave the transaction log using default settings. It's as if it doesn't matter, just an afterthought, a relic of the platform architecture.
In this session you will learn to appreciate how the transaction log works and how you can improve the performance of your applications by making the right architectural choices.
Sorry, there are no downloads available for this session.
Richard Douglas is a Systems Consultant and SQL Server Evangelist for Dell Software where he specialises in providing SQL Server solutions and system health checks to organisations across the EMEA region. Richard is the founder and organiser of the Maidenhead SQL Server User Group and has spoken at several PASS events including the PASS Summit, SQL Rally's and SQL Saturdays. Richard also regularly presents webinars for Dell Software and PASS Virtual Chapters on various SQL Server related topics and was a technical reviewer on two SQL Server 2012 books.
Richard can be contacted via Twitter @SQLRich or on his blog http://SQL.RichardDouglas.co.uk
The video is not available to view online.