What Is The Purpose Of The Tempdb Database?

1.	What Is The Purpose Of The Tempdb Database?
Answer» Tempdb database KEEPS the INFORMATION about the temporary objects (#TABLENAME, #Procedure). Also the SORTING, DBCC operations are PERFORMED in the TempDB. Tempdb database keeps the information about the temporary objects (#TableName, #Procedure). Also the sorting, DBCC operations are performed in the TempDB.

Answer»

Tempdb database KEEPS the INFORMATION about the temporary objects (#TABLENAME, #Procedure). Also the SORTING, DBCC operations are PERFORMED in the TempDB.

Tempdb database keeps the information about the temporary objects (#TableName, #Procedure). Also the sorting, DBCC operations are performed in the TempDB.

Discussion

No Comment Found

Related InterviewSolutions

Can You Use The On Delete And On Update In The Same Constraint?
What Is The Purpose Of The Model Database?
What Is The Purpose Of The Master Database?
What Is The Purpose Of The Tempdb Database?
What Is The Purpose Of The Use Command?
If You Delete A Table In The Database, Will The Data In The Table Be Deleted Too?
What Is The Parse Query Button Used For?
What Is Usually The First Word In A Sql Query?
Does A Sql Server 2005 Select Statement Require A From?
What Is The Order By Used For?

What Is The Purpose Of The Tempdb Database?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment