posted on Thursday, April 07, 2005 6:54 AM
by
amachanic
SQL Server 2000 I/O Basics
Via Karen Watterson's SQL Blog:
Yet another great Technet article that I missed when it was published!
This one appeared in January, and is called SQL Server 2000 I/O Basics. It's a very informative look at how SQL Server maintains those wonderful ACID properties we know and love, in order to maintain data integrity. If terms such as Write-Ahead Logging, Scatter-Gather, Checkpoint, and Lazy Writer are somewhat nebulous to you, you'll want to read this article.