CONTENIDO:
1. VIEWS WHAT ARE VIEWS?
ORDER BY in a View
Refreshing Views
Modular Approach
Updating Views
View Options
Indexed Views
Conclusion
2. USER-DEFINED FUNCTIONS SOME FACTS ABOUT UDFS
Scalar UDFs
Table-Valued UDFs
Per-Row UDFs
Conclusion
3. STORED PROCEDURES TYPES OF STORED PROCEDURES
The Stored Procedure Interface
Resolution
Dependency Information
Compilations, Recompilations, and Reuse of Execution Plans
EXECUTE AS
Parameterizing
Sort Order
CLR Stored Procedures
Conclusion
4. TRIGGERS AFTER TRIGGERS
DDL Triggers
Logon Triggers
CLR Triggers
Conclusion
5. TRANSACTIONS AND CONCURRENCY WHAT ARE TRANSACTIONS?
Locking and Blocking
Lock Escalation
Isolation Levels
Savepoints
Deadlocks
Conclusion
6. ERROR HANDLING ERROR HANDLING WITHOUT THE TRY/CATCH CONSTRUCT
Error Handling with the TRY/CATCH Construct
Conclusion
7. TEMPORARY TABLES AND TABLE VARIABLES TEMPORARY TABLES
Table Variables
tempdb Considerations
Table Expressions
Comparison Summary
Summary Exercises
Conclusion
8. CURSORS USING CURSORS
Cursor Overhead
Dealing with Each Row Individually
Order-Based Access
Conclusion
9. DYNAMIC SQL EXEC
sp_executesql
Environmental Settings
Uses of Dynamic SQL
SQL Injection
Conclusion
10. WORKING WITH DATE AND TIME DATE AND TIME DATA TYPES
Date and Time Manipulation
Date- and Time-Related Querying Problems
Conclusion
11. CLR USER-DEFINED TYPES THEORETICAL INTRODUCTION TO UDTS
Programming a UDT
Conclusion
12. TEMPORAL SUPPORT IN THE RELATIONAL MODEL TIMESTAMPED PREDICATES AND PROPOSITIONS
Semitemporal Problems
Tables with Full Temporal Support
Unpack and Pack
Sixth Normal Form in Use
Conclusion
13. XML AND XQUERY CONVERTING RELATIONAL DATA TO XML AND VICE VERSA
The XQuery Language in SQL Server 2008
XML Data Type
Dynamic Relational Schema
Conclusion
14. SPATIAL DATA INTRODUCTION TO SPATIAL DATA
Basic Spatial Data Concepts
Data
Getting Started with Spatial Data
Spatial Data Validity Measuring Length and Area
Indexing Spatial Data
Using Spatial Data to Solve Problems
Extending Spatial Support with CLR Routines
Conclusion
15. TRACKING ACCESS AND CHANGES TO DATA WHICH TECHNOLOGY DO I USE?
Extended Events Implementation
SQL Server Audit Implementation
Change Tracking Implementation
Change Data Capture Implementation
Conclusion
16. SERVICE BROKER DIALOG CONVERSATIONS
Activation
Conversation Priority
Sample Dialog
Poison Messages
Dialog Security
Routing and Distribution
Troubleshooting
Scenarios
Where Does Service Broker Fit?
Conclusion
Appendix : Companion to CLR Routines
Create the CLRUtilities Database: SQL Server
Development: Visual Studio
Deployment and Testing: Visual Studio and SQL Server
Appendix : About the Author
