what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

1 Answers  

---

What is SQL Profiler what is the use of it?

2 Answers   247Customer, Steria,

---

difference between function and procedure

3 Answers   Cognizant, HCL, TCS, Theorem,

---

What are the components of sql server service broker?

1 Answers  

---

What is a unique index?

1 Answers  

---

What is index fragmentation in ms sql server?

1 Answers  

---

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  

---

What is the difference between for xml raw and for xml auto?

0 Answers  

---

What is the difference between cartesian product and cross join?

1 Answers  

---

What does it mean to normalize data?

1 Answers  

---

What is RAID and what are different types of RAID configurations?

8 Answers   Wipro,

---

plz send every query in sql server2000

1 Answers   Infosys,

---