SQL Server 2005 T-SQL Recipes

1. Select

2. Insert, Update, Delete

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

15. Web Services

16. Error Handling

17. Principals

18. Securables and Permissions

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. Performance Tuning

29. Backup and Recovery

Nyckelord: COMPUTERS / Computer Science COM014000