What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  

---

How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?

1 Answers   Logitech, Mphasis,

---

Is foreign key a primary key?

0 Answers  

---

What is an execution plan? When would you use it?

0 Answers  

---

what is the main difference between constraints(like primary key etc..)& joins?

2 Answers  

---

What are the differences between lost updates and uncommitted dependencies?

0 Answers  

---

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO

1 Answers   Cognizant,

---

How will you optimize a stored procedure optimization?

0 Answers  

---

write sql program to get the detail of student in a class?

2 Answers  

---

What is NOT NULL Constraint in sql server 2012?

0 Answers   CDC,

---

What is temporary table in sql server? Why we use temp table?

0 Answers  

---

What are .mdf files?

0 Answers  

---