Preface |
|
vii | |
Acknowledgments |
|
xiii | |
FRIDAY |
|
2 | (2) |
Part I---Friday Evening |
|
4 | (44) |
|
|
5 | (14) |
|
|
19 | (10) |
|
First Look at Enterprise Manager Console |
|
|
29 | (8) |
|
Second Look at Enterprise Manager Console |
|
|
37 | (11) |
SATURDAY |
|
48 | (2) |
Part II---Saturday Morning |
|
50 | (74) |
|
Relational Database Concepts |
|
|
51 | (10) |
|
|
61 | (12) |
|
Creating and Using a Custom Database |
|
|
73 | (8) |
|
Transact-SQL Programming Language |
|
|
81 | (14) |
|
T-SQL and SQL Query Analyzer |
|
|
95 | (12) |
|
|
107 | (17) |
Part III---Saturday Afternoon |
|
124 | (66) |
|
Creating and Using Stored Procedures |
|
|
125 | (12) |
|
|
137 | (8) |
|
|
145 | (10) |
|
|
155 | (12) |
|
Rules, Defaults, and Constraints |
|
|
167 | (10) |
|
Understanding Transactions and Locks |
|
|
177 | (13) |
Part IV---Saturday Evening |
|
190 | (48) |
|
Data Transformation Services |
|
|
191 | (10) |
|
|
201 | (12) |
|
|
213 | (12) |
|
|
225 | (13) |
SUNDAY |
|
238 | (2) |
Part V---Sunday Morning |
|
240 | (68) |
|
Managing Your Databases Visually |
|
|
241 | (10) |
|
Distributed Transaction Coordinator |
|
|
251 | (12) |
|
Accessing SQL Server System Information |
|
|
263 | (10) |
|
Automating Administration Tasks with SQL Server Agent |
|
|
273 | (10) |
|
Configuring SQL Server Mail |
|
|
283 | (10) |
|
Performance Tuning and Optimization |
|
|
293 | (15) |
Part VI---Sunday Afternoon |
|
308 | (47) |
|
|
309 | (10) |
|
|
319 | (12) |
|
|
331 | (10) |
|
Advanced Features of Microsoft SQL Server 2000 |
|
|
341 | (14) |
Appendix A-Answers to Part Reviews |
|
355 | (12) |
Appendix B-What's on the CD-ROM? |
|
367 | (4) |
Index |
|
371 | (12) |
Hungry Minds, Inc. End-User License Agreement |
|
383 | (3) |
CD-ROM Installation Instructions |
|
386 | |