文件名称：Inside Microsoft SQL Server 2000
文件大小：3.44MB
文件格式：RAR
更新时间：2012-03-15 17:32:48
sql
Part I Overview 1. The Evolution of Microsoft SQL Server: 1989 to 2000 [加入我的離線書架] . SQL Server: The Early Years . Ron's Story . Kalen's Story . Microsoft SQL Server Ships . Development Roles Evolve . OS/2 and Friendly Fire . SQL Server 4.2 . SQL Server for Windows NT . Success Brings Fundamental Change . The End of Joint Development . The Charge to SQL95 . The Next Version . The Secret of the Sphinx . Software for the New Century 2. A Tour of SQL Server [加入我的離線書架] . The SQL Server Engine . DBMS-Enforced Data Integrity . Transaction Processing . Symmetric Server Architecture . Security . High Availability . Distributed Data Processing . Data Replication . Systems Management . SQL Server Utilities and Extensions . Client Development Interfaces . Summary Part II Architectural Overview 3. SQL Server Architecture [加入我的離線書架] . The SQL Server Engine . Managing Memory . Transaction Logging and Recovery . The SQL Server Kernel And Interaction With The Operating System . Summary Part III Using Microsoft SQL Server 4. Planning for and Installing SQL Server [加入我的離線書架] . SQL Server Editions . Hardware Guidelines . Hardware Components . The Operating System . The File System . Security and the User Context . Licensing . Network Protocols . Collation . Multiple Instances . Installing SQL Server . Basic Configuration After Installation . Remote and Unattended Installation . Summary 5. Databases and Database Files [加入我的離線書架] . Special System Databases . Database Files . Creating a Database . Expanding and Shrinking a Database . Changes in Log Size . Using Database Filegroups . Altering a Database . Databases Under the Hood . Setting Database Options . Other Database Considerations . Backing Up and Restoring a Database . Summary 6. Tables [加入我的離線書架] . Creating Tables . User-Defined Datatypes . Identity Property . Internal Storage . Constraints . Altering a Table . Temporary Tables . System Tables . Summary 7. Querying Data [加入我的離線書架] . The SELECT Statement . Joins . Dealing with NULL . Subqueries . Views and Derived Tables . Other Search Expressions . Summary 8. Indexes [加入我的離線書架] . Index Organization . Creating an Index . The Structure of Index Pages . Index Space Requirements . Managing an Index . Special Indexes . Using an Index . Summary 9. Modifying Data [加入我的離線書架] . Basic Modification Operations . Data Modification Internals . Summary 10. Programming with Transact-SQL [加入我的離線書架] . Transact-SQL as a Programming Language . Transact-SQL Programming Constructs . Transact-SQL Examples and Brainteasers . Full-Text Searching . Summary 11. Batches, Stored Procedures, and Functions [加入我的離線書架] . Batches . Routines . Stored Procedures . User-Defined Functions . Rewriting Stored Procedures as Functions . Rolling Your Own System Routines . Executing Batches,or What's Stored About Stored Procedures (and Functions)? . Temporary Stored Procedures . Autostart Stored Procedures . System Stored Procedures . Execute("any string") . Summary 12. Transactions and Triggers [加入我的離線書架] . Transactions . Triggers . Summary 13. Special Transact-SQL Operations: Working with Cursors and Large Objects [加入我的離線書架] . Cursor Basics . Cursors and ISAMs . Cursor Models . Appropriate Use of Cursors . Working with Transact-SQL Cursors . Cursor Variables . Working with Text and Image Data . Summary Part IV Performance and Tuning 14. Locking [加入我的離線書架] . The Lock Manager . Lock Types for User Data . Lock Compatibility . Internal Locking Architecture . Bound Connections . Row-Level vs. Page-Level Locking . Locking Hints and Trace Flags . Summary 15. The Query Processor [加入我的離線書架] . The SQL Manager . Compilation and Optimization . The Procedure Cache . Using Stored Procedures and Caching Mechanisms . Execution . Summary 16. Query Tuning [加入我的離線書架] . The Development Team . Application and Database Design . Planning for Peak Usage . Perceived Response Time for Interactive Systems . Prototyping, Benchmarking, and Testing . Creating Useful Indexes . Monitoring Query Performance . Concurrency and Consistency Tradeoffs . Resolving Blocking Problems . Resolving Deadlock Problems . Segregating OLTP and DSS Applications . Environmental Concerns . Summary 17. Configuration and Performance Monitoring [加入我的離線書架] . Operating System Configuration Settings . SQL Server Configuration Settings . System Maintenance . Monitoring System Behavior . Summary Bibliography and Suggested Reading