Answer / dharmendra k. dixit

Master , MSDB and TempDB
these are the inbuild Database which r provided by SQL
SERVER.
All have their own functinality & responsbility like.

1. Master : Master DB is responsible for Storing all
information at system level.
2. MSDB : it is Microsoft DB, it creates a Copy of whole
Database in it
3. TempDB : it stores all the log information of Server,
it will initilize automatically wheneve Server will start,
the max. size alloted fro TempDB is 10MB.

Thanks & Regards
Dharmendra k. Dixit

Answer / pinak

the basics function of master is "it stores all sytem level
information in it, all databases which need for user
defineed database.
msdb is microsoft database.it works just like a recorder.

tempdb is a temprary database.

What is the difference between varchar and nvarchar?

0 Answers  

---

what is cluster and nin-cluster index?

4 Answers  

---

How do I know if localdb is running?

0 Answers  

---

What is the difference between having and where clause?

4 Answers  

---

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

0 Answers  

---

---

What happens on checkpoint?

0 Answers  

---

What is analysis service repository?

0 Answers  

---

Can you explain what is sql server english query?

0 Answers  

---

WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX

4 Answers   CarrizalSoft Technologies, L&T,

---

what is denormalization and when would you go for it? : Sql server database administration

0 Answers  

---

but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

0 Answers  

---

What is the main purpose of having conversation group?

0 Answers  

---