SQL Server 2005 T-SQL Recipes A Problem-Solution Approach /

Detalles Bibliográficos
Autor principal: Sack, Joseph. (Autor)
Autor Corporativo: SpringerLink (Online service)
Formato: eBook
Lenguaje:English
Publicado: Berkeley, CA : Apress : Imprint: Apress, 2006.
Edición:1st ed. 2006.
Materias:
Acceso en línea:https://doi.org/10.1007/978-1-4302-0099-4
Tabla de Contenidos:
  • 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.