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.