We have an application that is generating thousands of unique select statements. This is causing the tempdb to continue to grow because the statements are getting stored in the tempdb. Is there any way to limit the size of the statements that are stored, or disable completely?
what do you mean by "generating thousands of unique select statements"? Does this mean generates numerous select statements with distinct (i.e. SELECT DISTINCT, SELECT DISTINCT, SELECT DISTINCT..) OR a SELECT DISTINCT statement returning thousands of records?