Rate yourself in .NET and SQL ?

1 Answers   Cognizant, HCL, SunGard,

---

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

0 Answers  

---

explain query execution plan

1 Answers  

---

What is a not null constraint?

0 Answers  

---

If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?

3 Answers  

---

---

What are the steps you can take to avoid “deadlocks”?

0 Answers  

---

What are the rules to use the rowguidcol property to define a globally unique identifier column?

0 Answers  

---

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

0 Answers  

---

What are transactions and its controls?

0 Answers  

---

What do you understand by mirroring and mention the advantages of the mirroring?

0 Answers  

---

What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ?

4 Answers   Wipro,

---

How to drop an existing user defined function in ms sql server?

0 Answers  

---