SQL Server Database

1. Database:

Structured Query Language (Structured Query Language) abbreviated to SQL;

DBMS (Database Management system) for short;

The database administrator (DB Administration) is called DBA, and the function is to ensure the normal and efficient operation of DBMS;

Database sub-experience version (generally only install library files and services) and the official version (authorized use);

In the formal team development, generally only install the interface, log on to the server common operation of the database, so as to avoid the database of each individual can not be combined.

2.SQL Server 2008 Mode:

(1) client/server (c/s)

(2) Browser/server (b/s)

3. Database files:

A database can store up to 32,767 data files and 32,767 log files

Name Purpose extension
The primary file stores the data, the boot information must be available, and only one
Mdf

Minor file Store the primary file is not stored in the number of unnecessary, can be less
Ndf

Log file Logging operation information must have and at least one
Ldf

PS: A file or filegroup can be used only for one database and not for multiple databases.

A file can only be a member of a filegroup and cannot be a member of more than one filegroup.

The log file can never be a member of any filegroup.

Data information and log information cannot be placed in the same file or filegroup.

4. Database System server Type:

(1) Database engine: Core Services, is a complex system, responsible for data storage, processing and security;

(2) Analysis Services: Analyze mining data, support the local cube engine, enable disconnected clients on the application to be able to store multidimensional data in the local browser;

(3) Reporting Services: report Server management tools;

(4) Intergration Services: Responsible for data extraction, conversion and loading operations, can efficiently handle a variety of data sources. Example: Oracle, Excel, XML document, etc.;

(5) SQL Server Compact Edition: not part of SQL Server 2008, it is a powerful lightweight relational database engine.

5. Database Products:

Oracle

IBM DB2, Informix

Sybase Sybase Ase

Microsoft Access, Microsoft SQL Sever

My SQL Open Source db

Ps:microsoft SQL Sever 2008 code name is: Katmai

The system database in the database contains the master, Tempdb, model, and msdb types.

Data storage units for 6.SQL Sever 2008:

(1) Page: the most basic unit.

8KB is a page, 128 pages is 1MB, starts with a 96B header,

The number of data bytes per row in the table cannot exceed 8192-96b (8192=1024*8)

(2) District: The basic unit of management space.

8 link pages are a zone, that is, 64KB is a zone, 16 zones are 1MB,

There is a mixed disk in the storage <64kb of the control table and index, only in 64KB.

7. Control the database services:

Run cmd

Input net start MSSQLserver start database service

Enter net stop MSSQLserver to shut down the database service

Enter net pause MSSQLserver to pause the database service

Input net continue MSSQLserver continue database service

Practice

1. Create a Student information sheet

2. Use an array to sort the scores of six students from high to low

SQL Server Database