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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-15 : 09:47:19
|
Angel writes "Hello Guru!!
I write from Basque Country. I have a problem with my database performance. I use an aplication (in VB 5.0) that executes a stored procedure (in SQL Server 7.0), when this sp is called the size of tempdb increase to the the limit and the server fails. In this procedure I need to create and drop a lot of temporal tables in order to pass data from VBasic to other procedures.
I only have an one unique transacction (large transacction).
How can I improve the performance of my aplication?
When the tempdb database is deleted?
Thanks.
Angel." |
|
|
|
|
|
Tempdb and performance.