Acknowledgments | p. xxiii |
Introduction | p. xxv |
Mastering Transact-SQL | |
An Overview of SQL Server 2000 | p. 3 |
SQL Server's Networked Architecture | p. 4 |
SQL Server's Basic Components | p. 8 |
Transact-SQL | p. 9 |
SQL Server Database Architecture | p. 9 |
Administrative Components | p. 22 |
A Brief Development History of SQL Server | p. 27 |
What's New with SQL Server 2000 | p. 28 |
Conclusion | p. 33 |
Data Definition Language Basics | p. 35 |
Introduction to SQL | p. 36 |
Creating a Database | p. 46 |
Creating a Table | p. 50 |
Creating a View | p. 70 |
Re-creating a View | p. 78 |
Creating an Index | p. 78 |
Dropping Databases, Tables, Views, and Indexes | p. 80 |
The SQL Catalog and Information Schema | p. 80 |
DDL Coding Suggestions | p. 83 |
Conclusion | p. 86 |
Additional Resources | p. 86 |
Advanced Database Definition | p. 87 |
Specifying Database File Locations and Sizes | p. 88 |
Altering a Database | p. 90 |
Defining Filegroups | p. 90 |
Cascading Foreign Key Constraints | p. 93 |
More View Examples | p. 95 |
Indexes Over Computed Columns and Views | p. 106 |
Using the Query Analyzer | p. 109 |
Adding Extended Object Properties | p. 117 |
Conclusion | p. 120 |
Data Manipulation Language Basics | p. 121 |
Introduction to DML | p. 122 |
Retrieving Rows with the Select Statement | p. 123 |
Using DML to Modify Table Data | p. 154 |
DML Coding Suggestions | p. 160 |
Conclusion | p. 161 |
Advanced DML Statement Features | p. 163 |
Complex Select Statements | p. 164 |
Performance Hints | p. 202 |
Concurrent Access and Resource Locks | p. 203 |
DML Coding Suggestions | p. 211 |
Conclusion | p. 211 |
Writing Stored Procedures, Triggers, and Functions | p. 213 |
Stored Procedures | p. 214 |
Triggers | p. 232 |
User-Defined Functions | p. 245 |
Debugging Stored Procedures, Triggers, and User-Defined Functions | p. 250 |
Conclusion | p. 253 |
Developing Extended Stored Procedures | p. 255 |
Extended Stored Procedures | p. 256 |
OLE Automation Stored Procedures | p. 276 |
Conclusion | p. 283 |
Additional References | p. 283 |
Windows Applications | |
Using ADO | p. 287 |
OLE DB and Universal Data Access | p. 288 |
OLE DB Architecture Overview | p. 288 |
ADO (ActiveX Data Objects) | p. 291 |
OLE DB and ADO Files | p. 293 |
ADO Architecture | p. 293 |
Adding the ADO Reference to Visual Basic | p. 295 |
Using ADO Objects with Visual Basic | p. 296 |
Advanced Database Functions Using ADO | p. 352 |
Conclusion | p. 380 |
Additional References | p. 380 |
Using the ODBC API | p. 381 |
ODBC Architecture | p. 383 |
Configuring an ODBC Data Source | p. 385 |
Conclusion | p. 426 |
Additional References | p. 426 |
Using DAO | p. 427 |
DAO Files | p. 429 |
DAO Architecture | p. 430 |
An Overview of Using DAO | p. 432 |
Adding the DAO Reference to Visual Basic | p. 432 |
Using DAO Objects with Visual Basic | p. 433 |
General Performance Tips for DAO and ODBC | p. 488 |
Conclusion | p. 489 |
Additional References | p. 489 |
Using ODBCDirect | p. 491 |
ODBCDirect Files | p. 493 |
ODBCDirect Architecture | p. 493 |
Adding the DAO Reference to Visual Basic | p. 494 |
An Overview of Using ODBCDirect | p. 495 |
Creating the DBEngine Object | p. 496 |
Creating an ODBCDirect Workspace Object | p. 496 |
Ending the DBEngine Object | p. 497 |
Connecting to SQL Server | p. 497 |
Retrieving Data with ODBCDirect | p. 501 |
Modifying Data with ODBCDirect | p. 513 |
Advanced Database Functions Using ODBCDirect | p. 521 |
Conclusion | p. 528 |
Additional References | p. 529 |
Using RDO | p. 531 |
RDO Files | p. 534 |
RDO Architecture | p. 534 |
An Overview of Using RDO | p. 535 |
Adding RDO 2.0 Objects to Visual Basic | p. 536 |
Using the RDO Objects with Visual Basic | p. 537 |
Advanced Topics | p. 563 |
Conclusion | p. 570 |
Additional References | p. 571 |
Web Applications | |
Using the Web Wizard | p. 575 |
Web Integration Using the Web Assistant Wizard | p. 576 |
Conclusion | p. 591 |
Using ASP and ADO | p. 593 |
Web and Database Integration Using ASP | p. 594 |
The ASP Object Model | p. 597 |
ASP Basics | p. 599 |
Using ADO Objects with ASP | p. 601 |
Advanced ADO-based Web Building Techniques | p. 641 |
Conclusion | p. 649 |
Additional References | p. 650 |
Using XML | p. 651 |
XML Basics | p. 653 |
SQL Server 2000's Support for XML | p. 655 |
Using XML Streams and ADO | p. 684 |
Conclusion | p. 692 |
Additional Resources | p. 692 |
Management and Analysis Applications | |
Using SQL-DMO | p. 695 |
Distributed Management Framework | p. 696 |
SQL-DMO Files | p. 705 |
Using SQL-DMO | p. 705 |
Building the SQL-DMO Sample Application | p. 713 |
Conclusion | p. 734 |
Developing Applications Using DTS | p. 735 |
An Overview of DTS | p. 736 |
Creating DTS Packages with the DTS Designer | p. 742 |
DTS Command Line Options | p. 760 |
Programming with DTS | p. 762 |
DTS Architecture | p. 762 |
Conclusion | p. 781 |
Additional References | p. 781 |
Full-Text Search and English Query | p. 783 |
Full-Text Catalogs and Searches | p. 784 |
English Query | p. 794 |
Conclusion | p. 831 |
Administration for the Developer | |
Managing Servers | p. 835 |
Overview of a SQL Server Installation | p. 836 |
Setting Enterprise Manager Properties | p. 847 |
Registering and Unregistering a Server | p. 849 |
Stopping, Starting, Pausing, and Continuing a Server | p. 854 |
Setting Server Properties | p. 855 |
Server Logins and Roles | p. 874 |
Working with SQL Server Agent | p. 875 |
Displaying Event Logs | p. 891 |
Viewing and Creating SQL Server Messages | p. 892 |
Working with Linked Servers | p. 894 |
Other Enterprise Manager Facilities | p. 897 |
Conclusion | p. 897 |
Managing Databases | p. 899 |
Managing Databases and Database Objects | p. 900 |
Copy Database Wizard | p. 927 |
Conclusion | p. 933 |
SQL Server Security | p. 935 |
Security Basics | p. 936 |
Setting Up Database Users | p. 947 |
Managing SQL Server Database Access | p. 977 |
Using Stored Procedures | p. 980 |
Permissions | p. 984 |
The Grant, Revoke, and Deny SQL Statements | p. 993 |
Role Permissions | p. 998 |
Stored Procedures and Permissions | p. 999 |
Ownership Chain | p. 1000 |
Database Security Principles and Guidelines | p. 1000 |
Conclusion | p. 1002 |
Backup and Recovery | p. 1003 |
Why Back Up the Database? | p. 1004 |
Backing Up Database Objects | p. 1005 |
Database Recovery | p. 1025 |
Backup and Recovery Server Options | p. 1035 |
Using a Standby Server | p. 1036 |
Conclusion | p. 1036 |
Database Performance Troubleshooting | p. 1037 |
Selecting the Appropriate Tool | p. 1039 |
SQL Profiler | p. 1042 |
Windows 2000 Server System Monitor | p. 1073 |
Enterprise Manager Current Activity Categories | p. 1096 |
Index Tuning Wizard | p. 1099 |
Showplan | p. 1106 |
Other Performance Tools | p. 1114 |
SQL Statement Hints | p. 1118 |
Hardware Considerations | p. 1125 |
Conclusion | p. 1126 |
Relational Database Concepts | |
Introduction to the Relational Database Model | p. 1129 |
Background: Database Management Systems | p. 1130 |
The Relational Database Model | p. 1135 |
Conclusion | p. 1157 |
Additional Resources | p. 1158 |
Introduction to Entity Relationship Diagrams (ERDs) | p. 1159 |
ERDs--A Design Tool | p. 1160 |
Basic ERD Concepts and Symbols | p. 1160 |
Adding Properties to ERDs | p. 1163 |
Multivalued Properties | p. 1165 |
Representing Associations | p. 1166 |
Exclusive Relationships | p. 1167 |
Entity Subtypes | p. 1168 |
When to Use ERDs | p. 1169 |
SQL Server Database Diagrams | p. 1171 |
Conclusion | p. 1178 |
Additional Resources | p. 1179 |
Appendixes | |
Maximum Capacities | p. 1183 |
System Capacities | p. 1184 |
Database Capacities | p. 1184 |
SQL Capacities | p. 1185 |
Creating and Editing UDL Files | p. 1187 |
Creating UDL Files on Windows 9x and NT Using Explorer | p. 1190 |
Creating UDL Files on Windows 2000 Using Explorer | p. 1191 |
Creating UDL Files Using the Data Link API | p. 1192 |
Conclusion | p. 1195 |
Index | p. 1197 |
Table of Contents provided by Syndetics. All Rights Reserved. |