UEU-co logo

0201700476_toc.html

[ Team LiB ]
Previous Section
Next Section

   
•  Table of Contents
•  Examples
Guru’s Guide to SQL Server Architecture and Internals, The
By
Ken Henderson
 
Publisher : Addison Wesley
Pub Date : October 24, 2003
ISBN : 0-201-70047-6
Pages : 1072
    Copyright
    List of Exercises
    Foreword
    Historical Perspective
    Preface
    Acknowledgments
    Introduction
   
 
About Books Online
   
 
About WinDbg
   
 
About the Fundamentals
   
 
About the “How-To”
   
 
About the Breadth of Topics
   
 
About C++
   
 
About Visual C++ 6.0
   
 
About the Terms and Knowledge Measures
   
 
About SQL Server Versions
   
 
About Master Programming
    About the Author
    Part 1. 
Foundations
   
 
Chapter 1. 
Overview
   
 
Chapter Overview
   
 
Chapter Pairs
   
 
About the Code
   
 
Chapter 2. 
Windows Fundamentals
   
 
The Win32 API
   
 
User Mode vs. Kernel Mode
   
 
Processes and Threads
   
 
Virtual Memory vs. Physical Memory
   
 
Subsystems
   
 
Dynamic-Link Libraries
   
 
Tools
   
 
Recap
   
 
Knowledge Measure
   
 
Chapter 3. 
Processes and Threads
   
 
Processes
   
 
Threads
   
 
Thread Scheduling
   
 
Thread Synchronization
   
 
Chapter 4. 
Memory Fundamentals
   
 
Memory Basics
   
 
Virtual Memory
   
 
Heaps
   
 
Shared Memory
   
 
Chapter 5. 
I/O Fundamentals
   
 
I/O Basics
   
 
Asynchronous and Nonbuffered I/O
   
 
Scatter-Gather I/O
   
 
I/O Completion Ports
   
 
Memory-Mapped File I/O
   
 
Chapter 6. 
Networking Fundamentals
   
 
Overview
   
 
Named Pipes
   
 
Windows Sockets
   
 
Remote Procedure Call
   
 
Recap
   
 
Knowledge Measure
   
 
Chapter 7. 
COM
   
 
Overview
   
 
Before COM
   
 
The Dawn of COM
   
 
Basic Architecture
   
 
COM at Work
   
 
Threading Models
   
 
COM and SQL Server
   
 
Recap
   
 
Knowledge Measure
   
 
Chapter 8. 
XML
   
 
Overview
   
 
Simplicity Comes at a Price
   
 
A Brief History of XML
   
 
XML vs. HTML: An Example
   
 
Document Type Definitions
   
 
XML Schemas
   
 
Converting XML to HTML Using a Style Sheet
   
 
The Document Object Model
   
 
Processing XML with MSXML
   
 
Resources
   
 
Recap
   
 
Knowledge Measure
    Part II. 
Subsystems, Components, and Technologies
   
 
Chapter 9. 
SQL Server as a Server
   
 
SQL Server and Networking
   
 
The SQL Server Executable
   
 
SQL Server’s DLLs
   
 
SQL Server I/O
   
 
SQL Server Components
   
 
Recap
   
 
Knowledge Measure
   
 
Chapter 10. 
User Mode Scheduler
   
 
UMS Design Goals
   
 
User Mode vs. Kernel Mode Scheduling
   
 
Preemptive vs. Cooperative Tasking
   
 
How UMS Takes Over Scheduling
   
 
The UMS Scheduler
   
 
The UMS Scheduler Lists
   
 
Going Preemptive
   
 
Hidden Schedulers
   
 
DBCC SQLPERF(umsstats)
   
 
Recap
   
 
Knowledge Measure
   
 
Chapter 11. 
SQL Server Memory Management
   
 
Memory Regions
   
 
Sizing
   
 
The BPool
   
 
Primitive Allocations
   
 
AWE
   
 
The Lazywriter
   
 
The Memory Managers
   
 
Pulling It All Together
   
 
Recap
   
 
Knowledge Measure
   
 
Chapter 12. 
Query Processor
   
 
Key Terms and Concepts
   
 
Parsing
   
 
Optimization Stages
   
 
Optimization Limits
   
 
Parameter Sniffing
   
 
Auto-Parameterization
   
 
Indexing
   
 
Statistics
   
 
Indexable Expressions
   
 
Join Order and Type Selection
   
 
Logical and Physical Operators
   
 
Recap
   
 
Knowledge Measure
   
 
Chapter 13. 
Transactions
   
 
The ACID Test
   
 
How SQL Server Transactions Work
   
 
Types of Transactions
   
 
Avoiding Transactions Altogether
   
 
Automatic Transaction Management
   
 
Transaction Isolation Levels
   
 
Transaction Commands and Syntax
   
 
Debugging Transactions
   
 
Optimizing Transactional Code
   
 
Recap
   
 
Knowledge Measure
   
 
Chapter 14. 
Cursors
   
 
Overview
   
 
On Cursors and ISAM Databases
   
 
Types of Cursors
   
 
Appropriate Cursor Use
   
 
Transact-SQL Cursor Syntax
   
 
Configuring Cursors
   
 
Updating Cursors
   
 
Cursor Variables
   
 
Cursor Stored Procedures
   
 
Optimizing Cursor Performance
   
 
Recap
   
 
Knowledge Measure
   
 
Chapter 15. 
ODSOLE
   
 
Overview
   
 
The sp_OA Procedures
   
 
Automating with ODSOLE
   
 
Automating SQL-DMO by Using ODSOLE
   
 
Using ODSOLE to Automate Custom Objects
   
 
Recap
   
 
Knowledge Measure
   
 
Chapter 16. 
Full-Text Search
   
 
Overview
   
 
Architectural Details
   
 
Setting Up Full-Text Indexes
   
 
Full-Text Predicates
   
 
Rowset Functions
   
 
Recap
   
 
Knowledge Measure
    Part III. 
Data Services
   
 
Chapter 17. 
Server Federations
   
 
Partitioned Views
   
 
Recap
   
 
Knowledge Measure
   
 
Chapter 18. 
SQLXML
   
 
Overview
   
 
MSXML
   
 
FOR XML
   
 
Using FOR XML
   
 
OPENXML
   
 
Using OPENXML
   
 
Accessing SQL Server over HTTP
   
 
URL Queries
   
 
Using URL Queries
   
 
Template Queries
   
 
Mapping Schemas
   
 
Updategrams
   
 
XML Bulk Load
   
 
Managed Classes
   
 
SQLXML Web Service (SOAP) Support
   
 
SQLXML Limitations
   
 
Recap
   
 
Knowledge Measure
   
 
Chapter 19. 
Notification Services
   
 
How It Works
   
 
Building Your Own Notification Application
   
 
Recap
   
 
Knowledge Measure
   
 
Chapter 20. 
Data Transformation Services
   
 
Overview
   
 
Packages
   
 
The Multiphase Data Pump
   
 
The Bulk Insert Task
   
 
The Data Driven Query Task
   
 
ActiveX Transformations
   
 
Other Types of Transformations
   
 
Lookup Queries
   
 
Workflow Properties
   
 
DTS and Transactions
   
 
Controlling Package Workflow through Scripting
   
 
Parameterized DTS Packages
   
 
The DSO Rowset Provider
   
 
Using DTS to Transform Replication Subscriptions
   
 
Custom Tasks
   
 
Controlling DTS through Automation
   
 
Recap
   
 
Knowledge Measure
   
 
Chapter 21. 
Snapshot Replication
   
 
Overview
   
 
The Snapshot Agent
   
 
Duties of the Snapshot and Distribution Agents
   
 
Updatable Subscriptions
   
 
Remote Agent Activation
   
 
Replication Cleanup
   
 
Recap
   
 
Knowledge Measure
   
 
Chapter 22. 
Transactional Replication
   
 
Overview
   
 
The MSrepl_commands Table
   
 
The sp_replcmds Procedure
   
 
The sp_repldone Procedure
   
 
Update Stored Procedures
   
 
Concurrent Snapshot Processing
   
 
Updatable Subscriptions
   
 
Validating Replicated Data
   
 
Skipping Errors
   
 
Cleanup
   
 
Recap
   
 
Knowledge Measure
   
 
Chapter 23. 
Merge Replication
   
 
Overview
   
 
Conflict Resolution
   
 
Generations
   
 
Filtering
   
 
Identity Range Management
   
 
Recap
   
 
Knowledge Measure
    Part IV. 
Undocumented SQL Server
   
 
Chapter 24. 
Finding Undocumented Features
   
 
The syscomments Gold Mine
   
 
Goodies in sysobjects
   
 
Scripting Undocumented and System Objects
   
 
The Profiler Treasure Trove
   
 
Snooping around in the Installation Scripts
   
 
DLL Imports
   
 
Recap
   
 
Knowledge Measure
   
 
Chapter 25. 
DTSDIAG
    Part V. 
Essays
   
 
Why I Really, Really Don’t Like Fish!
   
 
Pseudo-Techie Tactics 101
How to Make Yourself Appear to Be an Expert via Newsgroup Postings
   
 
CD-ROM Warranty

[ Team LiB ]
Previous Section
Next Section

Leave a Reply


Time limit is exhausted. Please reload the CAPTCHA.

Categories

apply_now Pepperstone Group Limited