1. Introduction to MS-SQL Server. Objectives Learn SQL Server 2000 components Contents What Are the SQL Server 2000 Components What Is the Relational Database Architecture Create databases Maintain databases Capacity and planning Prestanda measurement Practicals
storage on a client computer.
dynamically uses available physical memory as a data
buffer to minimize disk I/O and maximize performance.
Server computer where Active Directory directory
services are available, you can publish information
about SQL Server 2000 in Active Directory.
osql -Usa -s %1 -P %2 -i blddbase.qry -n
users, as well as temporary worktables used by the relational
database engine itself.
alerts and jobs, and recording operators.
Create database test1
C:\> osql –E –s localhost
1> create database test1
The generated script contain DROP DATABASE if it exists
options using SQL Server Enterprise
Manager or using the
DATABASEPROPERTYEX system function.
SELECT DATABASEPROPERTYEX (‘TSQLDB’, ’RECOVERY’)
If you need to create additional data
files or transaction log files
(either because the additional space
is on a separate drive or to enhance
performance by spreading
database files among multiple disks),
you can use SQL Server Enterprise Manager