SQL Server 2008 Transact-SQL Recipes

1. Select

2. Perform, Capture, and Track Data Modifications

3. Transactions, Locking, Blocking, and Deadlocking

4. Tables

5. Indexes

6. Full-Text Search

7. Views

8. SQL Server Functions

9. Conditional Processing, Control-of-Flow, and Cursors

10. Stored Procedures

11. User-Defined Functions and Types

12. Triggers

13. CLR Integration

14. XML, Hierarchies, and Spatial Data

15. Hints

16. Error Handling

17. Principals

18. Securables, Permissions, and Auditing

19. Encryption

20. Service Broker

21. Configuring and Viewing SQL Server Options

22. Creating and Configuring Databases

23. Database Integrity and Optimization

24. Maintaining Database Objects and Object Dependencies

25. Database Mirroring

26. Database Snapshots

27. Linked Servers and Distributed Queries

28. Query Performance Tuning

29. Backup and Recovery

Keywords: COMPUTERS / Computer Science COM014000