I would like to share these kind of things directly from SqlServerCentral, and not only posting links. But linking seems the best way to do it currently. Also I decided to increase that post count to 20 (yea, the yearly stats are post #19). Just for the fun of it 🙂
Be sure to read these quick tips (and discuss in the forums) because it may help you more than you can imagine. This is a greate piece by Rudy Panigas.
http://www.sqlservercentral.com/articles/Performance/119308/
I would like to add two little tips:
- Keep your app data on a single database. Cross-database queries are bad.
- Forget that Linked-Servers exist. Use other technology instead.
cya all next year!!!