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 |
|
Vishakha
Starting Member
40 Posts |
 Posted - 2006-06-14 : 23:27:44
|
| I am writing a report and it is a big report.I am using UDFs for generating reports and since my report size is big I am getting temp db full error.I can try the same with stored procs but then there i will either have to use derived tables and temporary tables which will result in same error.Can any one suggest what can be the workaround for really big reports, the UDF has around 10,000 rows in the table variable, which can increase in production enviornment. |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2006-06-15 : 02:49:06
|
quote:
Originally posted by Vishakha... the UDF has around 10,000 rows in the table variable
10,000 is NOT big!You may have to increase your TempDB size. What is the size of your biggest db? what is the size of tempdb?------------------------I think, therefore I am - Rene Descartes |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-06-15 : 04:48:15
|
quote:
Originally posted by Vishakha
I am writing a report and it is a big report.I am using UDFs for generating reports and since my report size is big I am getting temp db full error.I can try the same with stored procs but then there i will either have to use derived tables and temporary tables which will result in same error.Can any one suggest what can be the workaround for really big reports, the UDF has around 10,000 rows in the table variable, which can increase in production enviornment.
Post udf here I we'll take a look at it.Peter LarssonHelsingborg, Sweden |
|
|
|
sqldev80
Yak Posting Veteran
68 Posts |
Posted - 2006-06-15 : 12:29:28
|
| increase the tempdb sizei insert millions of rows in my tempdb |
|
|
|
Vishakha
Starting Member
40 Posts |
Posted - 2006-06-16 : 06:05:48
|
| How do you increase the size of tempDB, sorry I am very new to sqlserver |
|
|
|
sqldev80
Yak Posting Veteran
68 Posts |
Posted - 2006-06-16 : 16:18:55
|
go to enterprice manager and under the databases u will find the tempdb right click on it and look at the properties of the tempdb .select the Data Files from there and see whether the growth has been restricted. IF not what size has been aloocated to it and what is the growth percent. Try to allocate more space if it has been allocatted very less space. I would go for about 5000MB. Do not restrict file growth on tempdb. If someelse did it I don't know for what reason they would do that. Hope this helps. |
|
|
|
Vishakha
Starting Member
40 Posts |
Posted - 2006-06-20 : 06:06:26
|
| Thanks, I could increase the size of tempDB, it was set to 8 MB |
|
|
|
|
|
|
|
|
Temp DB becoming full