Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
robnielsen
Starting Member
2 Posts |
Posted - 2006-05-31 : 11:43:30
|
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? |
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-05-31 : 15:05:38
|
Is it in T-SQL or some other language ?U have the source code of the program?Srinika |
|
|
robnielsen
Starting Member
2 Posts |
Posted - 2006-05-31 : 15:13:49
|
No I don't have the source code. |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-05-31 : 15:32:21
|
Very hard to tell much, without u providing with more info as, what kind of a program is it ? Language it is written ? How it is connecting to the DB ? Whether the whole program is of no use etc.Do u want the selection to be stopped in SQL server's end ?All Selections or some selections ?Srinika |
|
|
cmdr_skywalker
Posting Yak Master
159 Posts |
Posted - 2006-05-31 : 20:31:28
|
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?May the Almighty God bless us all! |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-31 : 21:00:03
|
uninstall the apps? you can't control the size coz my guess they're dsql...you can however increase the size of the tempdb or allocated more drive space to itquote: Is there any way to limit the size of the statements that are stored, or disable completely?
--------------------keeping it simple... |
|
|
|
|
|