I use the CRecordset class requery() method of Visual C++ 5.0 MFCs instead of using open() and close() every time. They say that it is more efficient and that it takes less CPU time.
But I noticed ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10059142.html
I was getting this error about '...tempdb ... system segment is full...dump transaction..'
so i made a new device calling it tempdata and assigned Tempdb to it. I did not pay attention
to the...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10292756.html
Hello,
I was lead to believe that temporary tables were stored in memory when created, both data and definition!
However after running some tests I am not so sure.
Can anybody tell me whet...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20272985.html
Out of curiousity, what size should tempdb be? data and transaction, is there a formula to work it out or does nobody bother?
Thanks
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20509179.html
I'm getting an Error 9002 Severity 17 State 2 message not only in my events but also it pops up on my computer when I'm attached to another database on the SQL server. My message is the usual "Th...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21121751.html
I am interested in creating a table with a random name for temporary use then dropping it after a stored procedure is finished with it.
Is this better done with the #temp SQL feature?
If so w...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21132528.html
Hi All:
We have a web based applicatoin that uses SQL based session information storage in the TEMPDB. This is a .NET applicaiton. After initial testing, we found out that the TEMPDB is "recre...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21150905.html
For some reason, all of the sudden my tempdb has started growing to the limits of my harddrive space on the server and I can't figure out why. Yesterday, I was testing an sp that ended up running ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21387098.html
We have a performance problem that I think is related to tempdb.
Question: Which of the following SQL statements returning say 20,000 rows uses tempdb for the result set:
SELECT statement on...
http://www.experts-exchange.com/Database/Sybase/Q_21715326.html
Zones:
SybaseDate Answered: 01/30/2006 Grade: A Views: 0
My tempdb database is eating up all diskspace available every couple of days or so (growing to 40GB in size).
Would setting up a job to run once a day at night with this command:
use tempdb
...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21910950.html
