SQL SERVER 2008 Notes

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), which keeps track of the system as a whole.
? Model

The model database forms a template for any new database so you create. This means can, if you
Wish, alter the model database if you want to a change of 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 and database in that isn't only was the objects within it temporary, but
The database itself is temporary. It has the distinction of being the "database in your system"
Completely rebuilt from scratch every time you start your SQL Server.

3.Indexes

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

Clustered-you can has only one of these per table. If an index is clustered, it means the
Table on which the clustered index is based are physically sorted according to that index. If You
Were indexing an encyclopedia, the clustered index would is the page numbers; The information
In the encyclopedia are stored in the order of the page numbers.

Non-clustered-you can has many of these for every table. This kind of index points to some
Other value, that'll let you find the data. For we encyclopedia, this would is the keyword
Index at the back of the book.

SQL SERVER 2008 Notes