I don't pay much attention to the database related things, see this article, feel good:
"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 listed below article 10 Tips: 1) Replace COUNT (*) With EXISTS When Checking for Existence2) Be Careful When Using WHERE IN and WHERE nOT IN3) Randomize Resultset Orders With NewID () 4) Increase Default Packet Size for Large Data Fields5) Name Your SQL Server Applications6) Utilize SQL Server Aliases7) Disable Triggers Instead of Dropping Them8) Do not Rename Script-Based Objects9) Don't trust generated table model your apps with sql server profiler helpless English is too bad, can only look at Jinshan