Have you ever wondered about flushing databases? Well not quite possible to flush it straight away and not a best practice too on the live server, so what it is about and you need to know about transactions state when they occur. Say when the changes occur in a database the changes are formed as transactions that are held in buffer pool until the transaction commits or aborts. If it goes for abort operation then obviously those changes are discarded and if not for commit process, its changes become...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/tools/archive/2008/04/22/sql-server-databases-checkpoint-cache-and-i-o-request-what-you-need-to-know.aspx