Answer / Sadhana Dhaka

{"Clustered Index on Composite Key":[n "Yes, it is possible to create a clustered index on multiple columns (composite key)",n "Composite keys should be unique and should follow specific ordering rules"n]}

How to verify the port number of the sql server?

1 Answers  

---

How to use clusters?

1 Answers   Amdocs,

---

what purpose does the model database serve? : Sql server database administration

1 Answers  

---

WHICH IS THE BEST INSTITUTE IN HYD FOR "ORACLE"?

3 Answers  

---

What is row_number function?

1 Answers  

---

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

1 Answers  

---

What is transactional replication?

1 Answers  

---

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

6 Answers   Tech Mahindra,

---

Find columns used in stored procedure?

1 Answers  

---

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

1 Answers  

---

How secure is sql server database?

1 Answers  

---

What is a bit datatype?

1 Answers  

---