MiniMe to the rescue - Simple but effective performance tuning trick
Happy Thanksgiving! We wish everyone a great thanksgiving and if you are stuck babysitting SQL server, we salute you! You suppor the infrastructure of the modern world. And that's a noble thing. Here's another SQL Query performance optimization tip that is so simple in concept and actually works pretty well, often cutting down query execution time two or three folds. If you are joining a big table many times in a query, consider plucking off the small subset of that big table
