Chapter 3. Creating Databases, Files, and Tables
IN THIS CHAPTER, YOU WILL LEARN TO DO THE FOLLOWING:
▸ PERFORM CAPACITY PLANNING (Pages 76 – 82)
SQL Server I/O Processes (Page 77)
Disk Capacity Planning (Page 79)
Memory Capacity Planning (Page 82)
▸ CREATE AND ALTER DATABASES (Pages 83 – 98)
Create a Database (Page 84)
Alter a Database (Page 92)
Drop a Database (Page 96)
▸ MANAGE DATABASE FILES (Pages 98 – 109)
Add Files to a Database (Page 98)
Add Files to a Filegroup (Page 101)
Modify Database File Size (Page 104)
Deallocate Database Files (Page 107)
▸ CREATE AND ALTER TABLES (Pages 109 – 118)
Understand SQL Server Data Types (Page 109)
Create a Table (Page 112)
Alter a Table (Page 115)
Drop a Table (Page 117)
All the work to install and configure ...
Get SQL Server® 2008 Administration: Instant Reference 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.