How to delete existing rows in a table?

0 Answers  

---

Can we create clustered index on composite key?

0 Answers  

---

What is the difference between count and distinct count?

0 Answers  

---

What gets stored inside msdb database?

0 Answers   Abacus,

---

Explain what are the different index configurations a table can have?

0 Answers  

---

---

Does sql server 2000 clustering support load balancing?

0 Answers  

---

How to list all tables having unique constraints in any of the columns in a database.

1 Answers  

---

Can a unique index be created on a column, which contains null?

0 Answers  

---

What is the difference between stored procedure and functions?

0 Answers   MCN Solutions,

---

If the job running very slow what is the action you do

0 Answers  

---

Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?

5 Answers  

---

What is replication and database mirroring?

0 Answers  

---