|
|
|
Sql Server
|
|
By Nishant Kumar
Sql Server Tutorial
-
SQL
Server is a RDBMS, a complete database.
-
SQL
Server is compatible with structured query language and has rich
support for XML.
-
SQL
Server includes number of features that support ease of
installation, deployment, scalability, data warehousing and system integration
with other server software.
SQL
Server Components
Database
engine-It provides support for data access interfaces like ADO,
OLEDB and ODBC. Replication-It enables to maintain multiple
copies of data on different computers and also keep data well synchronized.
DTS-It
is for importing and transferring data from multiple heterogeneous sources. It
is used to build data ware housing and data marts by the process of extracting
data from multiple OLTP systems.
Analysis
services-It organizes data from data warehouse cubes to provide
rapid answers to complex queries. Analysis the data stored in data warehouse
and data marts.
Meta
data services-It is a set of services that helps to manage
metadata.
Metadata
describes meaning and description of applications and processes.
SQL
Server 2000 Architecture
-
SQL
Server has Logical Architecture and Physical Architecture.
-
The
data is organized into logical design that is visible to user.
-
Logical
components include objects, users, roles, collations, logins and groups.
-
The
database itself maintains data as files on disk.
-
Logical
components Objects include table, data type, view, stored procedure, function,
index, constraint, rule, default and trigger.
-
Collations
Control how character strings are stored physically and the rules by which
character are stored and compared.
-
Logins-Each
database user should have login id to allow database to identify.
-
Users
are who can connect to database.
-
Role
is a single unit of users having same permission.
-
Physical
Architecture-Page and extents describes physical database organisation.
-
Page
is the fundamental unit of data storage. Page is divided into data rows which
contain all data.
-
Extents
is the place where tables and indexes are stored.
Transact
SQL
-
Allow
us to create and manage all objects.
-
Client
application communicates with SQL server by transact-SQL
statement.
-
SQL
Server supports 3 types of transact-SQL statement namely DDL, DLL
and DML
|
|
|
|
|