Answer Posted / 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

What is the difference between Normalization and De-normalization?

1029

---

Explain throw statement in sql server 2008?

931

---

how can u get last observation in an unknown dataset ?

2387

---

How to get the definition of a view out of the sql server?

938

---

Explain the Ways to improve the performance of a sql azure database?

80

---

System variable and temporary variables

2183

---

What is the fastest way to permanently delete a 1 million row table named customers?

1152

---

Explain sql server service broker?

925

---

How to view the error log for any specific instance? : sql server database administration

985

---

What is sharding?

114

---

How can you list all the columns in a database?

885

---

Can sql servers link to other servers like oracle?

789

---

Explain where clause?

931

---

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

918

---

Call by value and call by reference in procedure and function, with NOCOPY.

1245

---