⟩ What is TEMPDB Database?
It stores temporary objects like temporary tables and temporary stored procedure.
Question and Answer:
Home MS SQL Server Architecture
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
What are user defined datatypes and when you should go for them?
What are statistics, under what circumstances they go out of date, how do you update them?
Let's assume you have data that resides on SQL Server 6.5. You have to move it SQL Server 7.0. How are you going to do it?
How to determine the service pack currently installed on SQL Server?
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
What is bit datatype and what's the information that can be stored inside a bit column?
What is denormalization and when would you go for it?
What are the different ways of moving data/databases between servers and databases in SQL Server?
Tell me what are the steps you will take to improve performance of a poor performing query?
When you create a database how is it stored?
