How do you know which index a table is using?

4 Answers  

---

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d

7 Answers   IBM, TCS,

---

How to write a query with a left outer join in ms sql server?

0 Answers  

---

Can we shrink data file in sql server?

0 Answers  

---

Explain tablesample?

0 Answers  

---

---

how can we use a composite key for two tables and how can we represent it

1 Answers   BoA,

---

Does transparent data encryption provide encryption when transmitting data across the network?

0 Answers  

---

can primery key be a non clustered index?

10 Answers  

---

Explain what you mean by 3 tier architecture.

0 Answers   TCS,

---

What is bit data type? What's the information that can be stored inside a bit column?

0 Answers  

---

How many types of Outer Joins?What are they?

1 Answers  

---

How do you check the performance of a query and how do you optimize it?

1 Answers  

---