Answer Posted / radhakrishnan

Join:

we are develop the table based on normalization
concept.data stored different table based on constraint.
when we required data from multiple table we need to use
Join clause.

we can use one or more than table in join caluse.

What is master database? : SQL Server Architecture

1013

---

how you can get the list of largest tables in a database? : Sql server administration

1042

---

What is sql server database?

995

---

What are the advantages of the mirroring?

1078

---

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? : Sql server database administration

946

---

Can you explain full-text query in sql server?

1003

---

Can you edit the .rdl code associated with a linked report?

163

---

What are the different types of locks in the database?

918

---

Explain nested join?

973

---

How do I install only the client tools of sql server 2000?

1061

---

What are the joins in sql server? : sql server database administration

998

---

Explain triggers?

997

---

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1133

---

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1938

---

What is difference between oltp and olap?

1032

---