I do agree... understanding the effects of compilation/recompilation on application performance is a worth while investigation. The moral, however, should be "avoid compilation if possible." Speaking anecdotally from...

We had a similar problem in one of our apps. The solution for us was to use the correct nhibernate types in the mapping.

Like you, our tables have Varchar....

ebaya (11/1/2010)

His illusory performance gain is explained entirely by the...

Did you clear the buffers between tests? Using: dbcc dropcleanbuffers

If not, it would explain your "performance gain", as the result is already in memory. Your "faster" query would...

Have you found root cause of why the tempdb is so large in the first place? If you don't fix the problem, it's just going to grow back that...

Not to beat a dead horse, but ultimately you need to find root cause. SQL Server uses the TempDB to perform sorts that don't fit in memory. Most-likely...

I recommend looking at The SQL Server Books Online: http://msdn.microsoft.com/en-us/library/ms151198.aspx (this is for 2008R2, but all versions are available).

The answer to your question depends on the...