what is the use of database index(apart from the last searching of records) and what is the use of composite key?

1 Answers  

---

What is an execution plan? When would you use it? How would you view the execution plan?

1 Answers  

---

Which data type columns are the best candidates for full-text indexing?

0 Answers  

---

If a stored procedure is taking a table data type, how it looks?

1 Answers  

---

What is the purpose of the tempdb database?

0 Answers  

---

---

What is sql server management studio? : sql server management studio

0 Answers  

---

What is the importance of concurrency control?

0 Answers  

---

Define Joins?

0 Answers   HCL,

---

what are three different authentications to connect linked servers?

1 Answers   CitiGroup,

---

What is compound operators?

0 Answers  

---

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

---

What is indexing a document?

0 Answers  

---