What is indexing explain it with an example?

0 Answers  

---

what stored procedure would you use to view lock information? : Sql server administration

0 Answers  

---

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

0 Answers  

---

What are the two modes of authentication in sql server?

0 Answers  

---

what is package configuration variable?How to change file name in folder dynamically?Plz help me

1 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,

---

How to find the latest updated value in a table without sending any parameters to that query

2 Answers  

---

How to transfer data from a cursor to variables with a "fetch" statement?

0 Answers  

---

What have included columns when we talk about sql server indexing?

0 Answers  

---

Can we use where and having clause together?

0 Answers  

---

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

0 Answers  

---

How do you size a resultset?

0 Answers  

---