2008 SQL Server Internals

Simply put, a Microsoft SQL Server database is a collection of objects that hold and
manipulate data. A typical SQL Server instance has only a handful of databases, but it’s not
unusual for a single instance to contain several dozen databases. The technical limit for one
SQL Server instance is 32,767 databases. But practically speaking, this limit would never
be reached.

To elaborate a bit, you can think of a SQL Server database as having the following properties
and features

2008-SQLServerInternals PDF Link

Related Posts:


SQL Server 2008 R2, like its predecessors, is more than a database engine. It is a