, - , SQL Server, SQL Server. , SQL Server SQL Server.
SQL Server: , Reporting Services, , , SQL Server.
SQL Server
SQL Server SQL Server, .
SQL Server Database Engine | SQL Server Database Engine Database Engine, , , , XML-. |
Analysis Services | Analysis Services (OLAP) . |
Reporting Services | Reporting Services , , , . Reporting Services , . |
Integration Services | Integration Services , . |
SQL Server Management Studio | SQL Server Management Studio , , , SQL Server. Management Studio SQL Server . Internet Explorer 6 1 Management Studio. |
SQL Server | SQL Server , , SQL Server. |
SQL Server Profiler | SQL Server Profiler Database Engine Analysis Services. |
, . | |
Business Intelligence Development Studio | Business Intelligence Development Studio Analysis Services, Reporting Services Integration Services. Internet Explorer 6 1 BI Development Studio. |
DB-, ODBC OLE DB. |
|
|
SQL Server | SQL Server. | ||
SQL Server
SQL Server, .
SQL Server , . , , SQL Server.
, . MSSQLSERVER. SQL ServerExpress SQLExpress. . . SQL Server 2000, SQL Server 2005 SQL Server 2008.
SQL Server, . .
SQL Server, , SQL Server - Master, Resource, Model, Msdb Tempdb.
Master
, , , , .. , rebuildm.exe, Master . Master.
Resource
Resource , SQL Server, . Resource mssqlsystemresource.mdf mssqlsystemresource.ldf. SQL Server mssqlsystemresource.mdf; , .
SQL Server, sys.objects, Resource, sys . Resource , , sp_helpdb sys.databases.
Resource SQL Server . mssqlsystemresource.mdf , SQL Server . mssqlsystemresource.mdf , , Resource .
|
|
Model
, , , , . , <db name> , SQL Model, 0.75 . , , , . . Model, , .
Msdb
SQL, . Msdb (task-scheduling), , , , .
Tempdb
, group by, order by, distinct .. Tempdb, SQL Server. : . SQL Server, . SQL Server. , , , SQL Server. Tempdb SQL , SQL .
9
- ( ) , - .
MS SQL Server . MS SQL Server - , . , , . .
, , . . . . MDF.
; , . , . , Windows, , . NDF.
|
|
- , . . , , , . LDF.
, . , .
. , . , , .
MS SQL Server . . , f1 100 , f2 - 200 , f1 , f2- , .
, Database Engine . . , , . , . , . , . , . .
, , ( , RAID). , f1, f2 f3, fgroup1. fgroup1. , , . , RAID. , .
, .
, . . | |
, . |
. , . , .
, , , . .