What is the meaning of lock escalation and why/how to stop this? : sql server database administration

0 Answers  

---

What are the differences between sql server and mysql.

0 Answers  

---

How to use subqueries with the in operators in ms sql server?

0 Answers  

---

what is index seek and index scan?

2 Answers  

---

what is mean by constraints in sql?

5 Answers   Granada, IBM,

---

How to connect PK and FK?

2 Answers  

---

What is the use of MOVE keyword in restore command

3 Answers   IBM,

---

List the ways in which dynamic sql can be executed?

0 Answers  

---

Is it important for a database administrator to understand the operating system and file access?

0 Answers  

---

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

---

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

0 Answers   IBM,

---

How do we get current date in SQL Server 2000, Oracle, MS Access?

13 Answers  

---