What do you understand by a view?

0 Answers  

---

Can we create clustered index on composite key?

0 Answers  

---

How do I start sql server 2016?

0 Answers  

---

Mention the different types of triggers?

0 Answers  

---

What are partitioned views and distributed partitioned views?

0 Answers  

---

---

Differentiate between sql temp table vs table variable?

0 Answers  

---

what is integrated security (SSPI). why we use in the connection string?

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

---

how many non clustered index in sql server 2008,2010,2012

2 Answers   Accenture,

---

If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

1 Answers   Ness Technologies,

---

What are the hotfixes and patches in sql server?

0 Answers  

---

What is the difference between varchar and nvarchar types?

1 Answers  

---