What is b tree index?

0 Answers  

---

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

0 Answers  

---

In join, which clause in not used?

4 Answers   HCL, NIIT, TCS,

---

How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)

5 Answers   Infosys, McAfee,

---

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?

0 Answers  

---

---

What are ddl (data definition language) statements for tables in ms sql server?

0 Answers  

---

Explain transaction server auto commit?

0 Answers  

---

A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?

8 Answers   Infosys,

---

What is difference between Datepart() and Datename() in SqlServer?

0 Answers   Infosys,

---

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

0 Answers  

---

What is cross join in sql server joins?

0 Answers  

---

Can I run multiple instances of sql server 2000 at the same time on one computer?

0 Answers  

---