SQL Server 2000 handbook
This 90 page book contains a comprehensive description of the major features of SQL Server 2000 and many technical notes on performance and programming issues.
The SQL Sever 2000 Handbook is now available online.
The book is designed for programmers who need to look at the power of SQL Server beyond simple queries and data update applications. Most areas of SQL Server implementation are covered including:
- SQL Server Tools including the Enterprise Manager.
- SQL syntax including different methods for joining tables and complex select criteria involving sub-queries.
- Defining a database table and associated indexes and specifying field properties, constraints, relationships between tables and referential integrity.
- Different views available including partitioned views and the integration of data from other database management systems.
- Stored procedures, the Transact-SQL programming language and parameters, output parameters, and return values.
- Using triggers to program business rules and data validation into the database management system.
- Optimisation techniques.
- Server configuration and security.
All topics are covered in a concise manner at a high level and the SQL Server Handbook is useful both as an introduction and as a reference used together with the full documentation from Microsoft.
1. CONTENTS 3
2. SQL SERVER OVERVIEW 6
3. SQL TOOLS 12
4. SQL SYNTAX 17
5. DATABASE DEFINITION 26
6. INDEXES 43
UNIQUE INDEX CONSTRAINT 43
CLUSTERED INDEX 43
7. VIEWS 45
8. STORED PROCEDURES 49
9. TRIGGERS 66
10. SQL SERVER OPTIMISATION 74
11. CONFIGURATION 82
12. SECURITY 85
13. INDEX 90