What is the datatype of rowid?

0 Answers  

---

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

0 Answers  

---

Why do we use sql limitations? Which constraints can we use while making a database in sql?

0 Answers  

---

What is referential integrity and how is it achieved?

1 Answers   Adea Solutions,

---

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

0 Answers  

---

Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement

3 Answers  

---

if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 as it is,how?

1 Answers  

---

What are the different ways you can create databases in sql server?

0 Answers  

---

What is the difference between online clustering and Offline clustering?

0 Answers   IBM,

---

why we use cursor?

4 Answers   CarrizalSoft Technologies, Melstar, TCS,

---

why would you call update statistics? : Sql server database administration

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  

---