I think there are PLENTY of common (and uncommon) ways for SQL Server based apps to perform suboptimally. 🙂 Plus, just because some schmo like me says something shouldn't be done on this forum doesn't mean many people will a) see my statement and b) actually listen to it. 😎
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service