As you all know tempdb is responsible of storing all the temporary objects created for a server. One of my co-workers asked me "what is the scope of permanent tables created in the tempdb database?". The answer is it can be accessed via tempdb from various connections just like objects are...
When you plan for TempDB configuration note the TempDB purpose. User objects e.g tables, indices, table variables. Scope (user session or routine) Internal objects. e.g join work files Scope (statement) Version Stores to support row versioning Some of the features using the TempDB are: Cursors Databse...
Someone in the forums asked about the internal storage of the temporary table. The questioner was complaining that the table was not stored in the database Let us consider this example create table #t(i int) Now check the existance of the table in information_schema.tables view select * from tempdb.information_schema...
As a DBA How many times you had to deal with TEMPDB during performance montiroing? As a Developer do you really care about TEMPDB when writing resource intensive queries? Within the last year how many times you had to increase size of TEMPDB or add more physical space to the drive where TEMPDB is located...
Sometimes we come across situation where in the Entire Space in TempDB will be unallocated space but we are unable to free up space neither we are able to shrink the database or file. This was how I was able to Free Up the unallocated space and it worked for me. So thought of sharing it. USE TempDB GO...
Some days back i was asked about Temp Tables and Table Variables the basic difference why one is better than another one and all, and i am not able to provide a satisfactory reason\answer at that time so this is the time when i studied about a lots about it and i go through several topics, it takes one...
Temporary database tempdb is created whenever the Server is restarted. So you can know when Server was restarted by knowing the creation date of the tempdb EXEC sp_helpdb tempdb select crdate from master..sysdatabases where name='tempdb'