平时不怎么留意数据库相关的东西，看到这篇文章，感觉不错：
《Speed Up SQL Server Apps》
Learn 10 useful tips and tricks that help boost SQL Server application performance—and streamline development and deployment as well
下面列举文章中的10条技巧：
- Replace COUNT(*) With EXISTS When Checking for Existence
- Be Careful When Using WHERE IN and WHERE NOT IN
- Randomize Resultset Orders With NewID()
- Increase Default Packet Size for Large Data Fields
- Name Your SQL Server Applications
- Utilize SQL Server Aliases
- Disable Triggers Instead of Dropping Them
- Don't Rename Script-Based Objects
- Don't Trust Generated Table Modification Scripts
- Examine Your Apps With SQL Server Profiler
无奈英文太差，只能就着金山词霸看 