Explain about protocol layer present in SQL server?

0 Answers  

---

How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

0 Answers   ABC,

---

How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table?

15 Answers   Leo Technologies, Mannar Company, Synechron,

---

which database is best to use in oracle and sql server? explain reasons?

5 Answers   TCS,

---

What is an example of a primary key?

0 Answers  

---

where do you use Isolations?give me some exmpale?

1 Answers  

---

Explain some stored procedure creating best practices or guidelines?

0 Answers  

---

Observed that some SP’s / Jobs are processing late, how to troubleshoot to improve performance?

1 Answers  

---

1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?

1 Answers   Techno Solutions,

---

How do you rebuild an identity column?

0 Answers  

---

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

9 Answers   Infogain,

---

How to use go command in "sqlcmd"?

0 Answers  

---