In which files does sql server actually store data?

0 Answers  

---

What is blocking and how would you troubleshoot it?

2 Answers  

---

Can you explain what is indexed view? How to create it?

0 Answers  

---

How to test values returned by a subquery with the in operator?

0 Answers  

---

How do clustered indexes store data?

0 Answers  

---

How do you fine the performance tunning?

2 Answers   Accenture,

---

How to loop through the result set with @@fetch_status?

0 Answers  

---

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

0 Answers   Verizon,

---

What are secondary xml indexes?

0 Answers  

---

which query u can write to sql server doesn't work inbetween 7.00PM to nextday 9.00AM

5 Answers   Wipro,

---

Explain the purpose of indexes?

0 Answers  

---

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,

---