Final Words

In this chapter, we've looked at the general workings of the SQL Server engine, including the key modules and functional areas that make up the engine. We've also looked at the interaction between SQL Server and the operating system. By necessity, I've made some simplifications throughout the chapter, but the information should provide some insight into the roles and responsibilities of the major components in SQL Server and the interrelationships among components.