Skip to Main Content
Microsoft® SQL Server® 2008 Administrator's Pocket Consultant, 2nd Edition
book

Microsoft® SQL Server® 2008 Administrator's Pocket Consultant, 2nd Edition

by William R. Stanek
April 2010
Intermediate to advanced content levelIntermediate to advanced
738 pages
22h 18m
English
Microsoft Press
Content preview from Microsoft® SQL Server® 2008 Administrator's Pocket Consultant, 2nd Edition

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® SQL Server® 2008 Administrator's Pocket Consultant

Microsoft® SQL Server® 2008 Administrator's Pocket Consultant

William R. Stanek

Publisher Resources

ISBN: 9780735645158Errata