What is the difference between clustered and a non-clustered index?

0 Answers   NA,

---

What is collation sensitivity? Explain different types.

0 Answers  

---

How to list all user defined functions in the current database?

0 Answers  

---

What is live lock and deadlock? what is Lock escalation?

2 Answers   Microsoft,

---

About types of indexes in SQL server ?

2 Answers   Cognizant,

---

Create and insert into temp table in sql server?

0 Answers  

---

What are the different types of joins and what does each do?

2 Answers  

---

Tell me about Triggers?

3 Answers   Cap Gemini,

---

List some of the rules that apply to creating and using a ‘view’

0 Answers  

---

What are indexes in sql?

1 Answers  

---

Write a SQL Query to find first Week Day of month?

2 Answers  

---

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

0 Answers  

---