SQL Server 2005 T-SQL Recipes A Problem-Solution Approach - Sack, Joseph; SpringerLink (Online service) (Berkeley, CA : Apress : Imprint: Apress, 2006)
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.
Keywords: Database management; Software engineering; Database Management; Software Engineering/Programming and Operating Systems