What is the default isolation level of the sql server database?

1 Answers   Ness Technologies,

---

Explain what are db_options used for?

1 Answers   InterGraph,

---

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,

---

What are Spatial data types in SQL Server 2008

0 Answers   Infosys,

---

Do you know 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  

---

What does it mean to normalize data?

0 Answers  

---

What is the appropriate number of test cases that you can write on a database?

2 Answers   Microsoft,

---

Does index speed up select statements?

0 Answers  

---

Is it possible to create trigger on views?

0 Answers  

---

What is cdc in sql server?

0 Answers  

---

You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

0 Answers  

---

I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000

17 Answers   HCL, IBM,

---