文件名称:
Inside Microsoft SQL Server 2000
开发工具:
文件大小: 3mb
下载次数: 0
上传时间: 2009-02-23
详细说明： 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 Eng ine . 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 ...展开收缩
(系统自动生成,下载前可以参看下载内容)
下载文件列表
相关说明
- 本站资源为会员上传分享交流与学习,如有侵犯您的权益,请联系我们删除.
- 本站是交换下载平台，提供交流渠道，下载内容来自于网络，除下载问题外，其它问题请自行百度。
- 本站已设置防盗链，请勿用迅雷、QQ旋风等多线程下载软件下载资源，下载后用WinRAR最新版进行解压.
- 如果您发现内容无法下载，请稍后再次尝试；或者到消费记录里找到下载记录反馈给我们.
- 下载后发现下载的内容跟说明不相乎，请到消费记录里找到下载记录反馈给我们，经确认后退回积分.
- 如下载前有疑问，可以通过点击"提供者"的名字，查看对方的联系方式，联系对方咨询.
