Top "Tempdb" questions

Temp Table collation conflict - Error : Cannot resolve the collation conflict between Latin1* and SQL_Latin1*

I can't update temp table. This is my query CREATE TABLE #temp_po(IndentID INT, OIndentDetailID INT, OD1 VARCHAR(50), OD2 …

sql sql-server collation tempdb
How tempDB works?

I am trying to understand the tempDB and following are the doubts popping in my mind. What is the lifetime …

sql sql-server tempdb
Failure SQL query insufficient disk space

Msg 1101, Level 17, State 10, Line 12 Could not allocate a new page for database 'TEMPDB' because of insufficient disk space in filegroup …

sql sql-server join view tempdb
SQL Server tempdb optimization tips for a new server?

I am planning a fresh installation of SQL Server 2005 on a new machine, which I have to order. I know …

sql-server performance configuration tempdb
Why are temporary tables not removed from tempdb in SQL Server?

I have created one stored procedure with 7 temporary tables and each temp table is dropped at the end of their …

sql sql-server temp-tables tempdb
Is it safe to delete the tempdb.mdf file manually?

In SQL Server 2008, I am trying to BULK INSERT a CSV that's about 1GB in size. As I'm doing so, …

sql-server shrink tempdb
How to insert into a temporary table?

I'm working with Sybase Central using Adaptive Server Anywhere 9 and I want some examples of how to use tempDB. How …

tempdb sybase-asa
Persistent temp tables in SQL?

Is it possible to have a 'persistent' temp table in MS-SQL? What I mean is that I currently have a …

sql sql-server tempdb
SQL Server Tempdb LOG file growing

On a SQL Server 2000 system, I have a templog.ldf file that seems to grow without bound! But when I …

sql-server-2000 size transaction-log tempdb
A very big size of tempdb

I have a spring project, when I start the server a named file 'tempdb' is created in the sql server …

sql-server spring tomcat tempdb