Answer Posted / subrahmanyam

Function is collection of T-Sql statements and used as unit
of reuse

What is onf in normalization form?

1063

---

List some major differences between triggers and stored procedures?

946

---

What is a non-clustered index?

1003

---

What is the difference between ddl and dml?

1059

---

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

1026

---

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

958

---

What is "scheduled jobs" or "scheduled tasks"?

985

---

What is the concept of optimization?

1067

---

What are the steps to process a single select statement?

951

---

What is the synonym of join?

967

---

Explain about unique identifier data type in sql server?

922

---

Can coalesce return null?

1024

---

What are the main sources of data?

1103

---

What sql server means?

972

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2354

---