SQL Server 2008 Transact-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, 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.