Answer Posted / prakash

magic table are thouse on which we manuclate on data

How do I run a trace in sql server?

928

---

Explain about system database?

998

---

How you can move data or databases between servers and databases in sql server?

999

---

How to provide values to stored procedure parameters in ms sql server?

973

---

How to create a new login name in ms sql server?

992

---

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

839

---

What is faster join or union?

1106

---

Difference between drill down and drill through report.

900

---

What is page in sql server?

895

---

Do you know what is normalization of database? What are its benefits?

1028

---

What do you mean by 'normalization'?

1001

---

What is the difference between a primary key and a unique key? Are they the same?

1006

---

Can a database be shrunk with users active?

1062

---

What is the server name for sql management studio?

947

---

what is database replication? : Sql server database administration

983

---