There are some problems with dynamic sql performance.
Can you give us your example script?
If SQL Server reuses the first compiled plan, it may not be optimal for successive calls.
If it keeps compiling, that is not ideal either.
Kalman Toth, Database Architect
SQL Server 2005 Training - http://www.sqlusa.com