SQL Server 2008 Transact-SQL Recipes A Problem-Solution Approach /
Autor principal: | |
---|---|
Autor Corporativo: | |
Formato: | eBook |
Lenguaje: | English |
Publicado: |
Berkeley, CA :
Apress : Imprint: Apress,
2008.
|
Edición: | 1st ed. 2008. |
Materias: | |
Acceso en línea: | https://doi.org/10.1007/978-1-4302-0625-5 |
Tabla de Contenidos:
- Select
- Perform, Capture, and Track Data Modifications
- 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, Hierarchies, and Spatial Data
- Hints
- Error Handling
- Principals
- Securables, Permissions, and Auditing
- 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
- Query Performance Tuning
- Backup and Recovery.