Export Ready — 

SQL Server 2008 Transact-SQL Recipes A Problem-Solution Approach /

Bibliographic Details
Main Author: Sack, Joseph. (Author)
Corporate Author: SpringerLink (Online service)
Format: eBook
Language:English
Published: Berkeley, CA : Apress : Imprint: Apress, 2008.
Edition:1st ed. 2008.
Subjects:
Online Access:https://doi.org/10.1007/978-1-4302-0625-5
Table of Contents:
  • 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.