Sitemap
Table of Content
Starting Page
Copyright
Foreword
Preface
Introduction
About the Sample Databases
Acknowledgments
About the Author
Part I: The Basics
Chapter 1. Stored Procedure Primer
What Is a Stored Procedure?
Stored Procedure Advantages
Creating a Stored Procedure
Altering Stored Procedures
Executing Stored Procedures
Extended Stored Procedures
Environmental Issues
Parameters
Flow Control Language
Errors
Nesting
Recursion
Summary
Chapter 2. Suggested Conventions
Source Formatting
Coding Conventions
Summary
Chapter 3. Common Design Patterns
The Law of Parsimony
Idioms
Design Patterns
Summary
Chapter 4. Source Code Management
The Benefits of Source Code Management
The dt Procedures
Best Practices
Version Control from Query Analyzer
Automating Script Generation with Version Control
Summary
Chapter 5. Database Design
General Approach
Modeling Tools
The Sample Project
The Five Processes
The Five Phases Examined
Modeling Business Processes
Entity-Relationship Modeling
Relational Data Modeling
Summary
Chapter 6. Data Volumes
Approaches to Generating Data
Speed
Summary
Part II: Objects
Chapter 7. Error Handling
Error Reporting
Handling Errors
Summary
Chapter 8. Triggers
Determining What Has Changed
Managing Sequential Values
Trigger Restrictions
INSTEAD OF Triggers
Triggers and Auditing
Transactions
Execution
Calling Stored Procedures
Nested Triggers
Disabling Triggers
Best Practices
Summary
Chapter 9. Views
Meta-data
Restrictions
ANSI SQL Schema Views
Updatable Views
The WITH CHECK OPTION Clause
Derived Tables
Parameterized Views
Dynamic Views
Partitioned Views
Indexed Views
Designing Modular Indexed Views
Summary
Chapter 10. User-Defined Functions
Scalar Functions
Table-Valued Functions
Inline Functions
Limitations
Meta-data
Creating Your Own System Functions
UDF Cookbook
Summary
Part III: HTML, XML, and NET
Chapter 11. HTML
Origins
Producing HTML from Transact-SQL
Producing HTML from sp_makewebtask
Summary
Chapter 12. Introduction to XML
Wooden Nickels
XML: An Overview
HTML: Simplicity Comes at a Price
XML: A Brief History
XML versus HTML: An Example
Document Type Definitions
XML Schemas
Extensible Stylesheet Language Transformation (XSLT)
Document Object Model
Further Reading
Tools
Summary
Chapter 13. XML and SQL Server: HTTP Queries
Accessing SQL Server over HTTP
URL Queries
Template Queries
Summary
Chapter 14. XML and SQL Server: Retrieving Data
SELECTFOR XML
RAW Mode
AUTO Mode
ELEMENTS
EXPLICIT Mode
Mapping Schemas
Summary
Chapter 15. XML and SQL Server: OPENXML
The Flags Parameter
Edge Table Format
Inserting Data with OPENXML()
Web Release 1
Limitations
Summary
Chapter 16. .NET and the Coming Revolution
.NET: The Future of Applications Development
What Is .NET?
On Microsoft Bashing
Microsoft Bigotry?
Summary
Part IV: Advanced Topics
Chapter 17. Performance Considerations
Indexing
Statistics
Query Optimization
Summary
Chapter 18. Debugging and Profiling
Debugging
Profiling
Stress Testing
Summary
Chapter 19. Automation
A Brief Overview of COM
SQL Server and COM Automation
Summary
Chapter 20. Extended Stored Procedures
Open Data Services
A Simple Example
A Better Example
Making Extended Procedures Easier to Use
Debugging Extended Procedures
Isolating Extended Procedures
xp_setpriority
Summary
Chapter 21. Administrative Stored Procedures
sp_readtextfile
sp_diff
sp_generate_script
Sp_start_trace
sp_stop_trace
sp_list_trace
sp_proc_runner
sp_create_backup_job
sp_diffdb
Summary
Chapter 22. Undocumented Transact-SQL
What Defines Undocumented?
Undocumented Procedures
Creating INFORMATION_SCHEMA Views
Creating System Functions
Undocumented DBCC Commands
Undocumented Trace Flags
Summary
Chapter 23. Arrays
xp_array.dll
Array System Functions
The Pice de Rsistance
Multidimensional Arrays
Summary
Part V: Essays on Software Engineering
Chapter 24. Creating a Workable Environment
Get Rid of Distractions
Close the Door
Internal Distractions
Form Over Function
Silence Is Golden; Communication Divine
Conclusion
Epilogue
Chapter 25. Evolutionary Development
Kaizen
The Benefits of Small Changes
Software
Software Entropy
Refactoring
Selling Management (or Yourself) on Refactoring
When Not to Refactor
Databases
Can You Refactor Instead of Design?
Code Extinction
Extreme Programming
Conclusion
Epilogue
Chapter 26. The Gestalt of Testing
Where to Begin
The Futility of Testing
Types of Tests
When to Test
Testing Can Save Time
Testing in the Extreme
Other Types of Testing
Conclusion
Epilogue
References
|
لطفا منتظر باشید ...
