Chapter 8. Core Database Administration
Core database administration involves creating, manipulating, and supporting databases. In Microsoft SQL Server 2008, a database is a collection of data and the objects that represent and interact with that data. Tables, views, stored procedures, triggers, and constraints are typical database objects.
A single database server instance can have up to 32,767 databases, and each database can have more than 2 billion objects. These are theoretical limits, of course, but they demonstrate that SQL Server can handle just about any job. To ...
Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant, 2nd Edition 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.
