Here's another brain dump that might be useful to lots of people. Have you ever wanted to search a whole database for any keyword or number but had to go through it one table and column at a time? Well, here's a great link that shows how to search all columns of all tables in a database. It has come in very handy for me on more than one occasion lately.
Thanks to Narayana Vyas Kondreddi for the procedure.