SQL Server 2005 T-SQL Recipes A Problem-Solution Approach /
| Main Author: | |
|---|---|
| Corporate Author: | |
| Format: | eBook |
| Language: | English |
| Published: |
Berkeley, CA :
Apress : Imprint: Apress,
2006.
|
| Edition: | 1st ed. 2006. |
| Subjects: | |
| Online Access: | https://doi.org/10.1007/978-1-4302-0099-4 |
Table of Contents:
- Select
- Insert, Update, Delete
- Transactions, Locking, Blocking, and Deadlocking
- Tables
- Indexes
- Full-Text Search
- Views
- SQL Server Functions
- Conditional Processing, Control-of-Flow, and Cursors
- Stored Procedures
- User-Defined Functions and Types
- Triggers
- CLR Integration
- XML
- Web Services
- Error Handling
- Principals
- Securables and Permissions
- Encryption
- Service Broker
- Configuring and Viewing SQL Server Options
- Creating and Configuring Databases
- Database Integrity and Optimization
- Maintaining Database Objects and Object Dependencies
- Database Mirroring
- Database Snapshots
- Linked Servers and Distributed Queries
- Performance Tuning
- Backup and Recovery.