Inside Microsoft® SQL Server™ 2005: T-SQL Querying

Other Performance Considerations

In this section, I’ll provide a brief background about designing and architecting write-intensive systems. I thought that such background might be interesting for programmers, particularly in terms of realizing that there’s a lot involved in designing systems when aiming for good modification performance. If you’re not familiar with the terms described in this section, feel free to skip it.

More Info

You can find more thorough coverage of the subject and more detailed explanations about the terms discussed here in Inside Microsoft SQL Server 2005: The Storage Engine (Microsoft Press, 2006) by Kalen Delaney.

You need ...