Chapter 3. Databases and database files
Kalen Delaney
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. Practically speaking, however, 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.
It’s a collection of many objects, such as tables, views, stored procedures, functions, and constraints. The technical limit is 231–1 (more than 2 billion) objects. The number of objects typically ranges from hundreds ...
Get Microsoft SQL Server 2012 Internals now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
