In our shop we have both professional SQL programmers and non professional SQL users.  The rampant use of dynamic SQL by the non-professionals is one of the most common sources of poor performance.  We handle this (but not always well) by isolating the non-professionals to their own server.