If you're new to the blog then you may not have seen my Search Engine Q&A series (or seen it and not realized what it is). It started out that I was watching the incoming search engine queries that hit the blog and worked out what common questions people were searching for, but then I turned it into a 'what are common problems on the forums that I see'. Anyway, there are a bunch of questions that I've answered that make some interesting reading and touch on some pretty diverse topics. Here they are in chronological order, with links. Don't forget that I fastidiously categorize all posts and you can use the category links on the left hand side of the blog.

1. Running out of transaction log space - how to tell why your log is growing and two common cases - no log backups and a long-running transaction
2. How to move a database while database mirroring is running
3. Mirroring - how long does it really take to detect a failure with database mirroring and how to combine mirroring and clustering
4. EMERGENCY mode - how to access a RECOVERY_PENDING or SUSPECT database
5. Multi-core vs. single-core CPU performance
6. Using the undocumented fn_dblog log analysis tool - how to see whether a transaction is contained in a backup
7. Multi-file backups - how to restore from a backup file containing multiple backups
8. How index maintenance can break mirroring
9. Updating constraints - how to update the constraints in the partitioning sliding-window scenario
10. Combining index and statistics maintenance
11. Designing a global-ready database
12. Multi-file databases to avoid contention - for tempdb and for user databases - should you? And the follow-on about the dangers of sweeping generalizations
13. Difference between database version and database compatibility level
14. How 3rd-party drivers can break DBCC CHECKDB
15. Using mirrored backups
16. Concurrent log and full backups
17. Backing up a VLDB - whether to split the VLDB into filegroups or smaller databases
18. Determining the uptime of SQL Server
19. Myths and misconceptions around index rebuilds
20. Database 'boot page' and boot page corruption
21. 'File header' pages and file header page corruption
22. Which pages cannot be single-page restored?
23. How to recover from a full transaction log
24. Why the transaction log can't be instant initialized
25. Why log backups aren't always the same size as the log itself
26. Myths around what can and cannot cause corruption
27. How does the storage engine find variable-length columns?

 Enjoy!