SQL SERVER 2008 笔记

1. Database Objects：

The database itself Indexes
The transaction log

CLR assemblies
Tables Reports
Filegroups

Full-text catalogs
Diagrams

User-defined data types
Views Roles
Stored procedures Users
User-defined functions

Encryption Keys

2.The Database Object

? master

This database holds a special set of tables (system tables) that keeps track of the system as a whole.
? model

The model database forms a template for any new database that you create. This means that you can, if you
wish, alter the model database if you want to change what standard, newly created databases look like.
? msdb

msdb is where the SQL Agent process stores any system tasks.
? tempdb

tempdb is very different from any other database in that not only are the objects within it temporary, but
the database itself is temporary. It has the distinction of being the only database in your system that is
completely rebuilt from scratch every time you start your SQL Server.

3.Indexes

An index is an object that exists only within the framework of a particular table or view.

Clustered— You can have only one of these per table. If an index is clustered, it means that the
table on which the clustered index is based is physically sorted according to that index. If you
were indexing an encyclopedia, the clustered index would be the page numbers; the information
in the encyclopedia is stored in the order of the page numbers.

Non-clustered — You can have many of these for every table. This kind of index points to some
other value that will let you find the data. For our encyclopedia, this would be the keyword
index at the back of the book.