Explain Different types of Projects?

1 Answers  

---

How to Create Login and User through query in Sql server 2005.and also how to delete Login and User through query?

2 Answers  

---

WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?

8 Answers  

---

How do you optimize Sql queries ?

0 Answers   Cognizant,

---

What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ?

4 Answers   Wipro,

---

An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).

9 Answers   ADP,

---

Explain the flow of creating a cube? : sql server analysis services, ssas

0 Answers  

---

What is primary key and example?

0 Answers  

---

How do I find sql server instance name?

0 Answers  

---

What are rows and columns?

0 Answers  

---

UPDATE statement can on a single table or on the multiple table?

7 Answers   iGate, TCS,

---

Does group by or order by come first?

0 Answers  

---