How can you see what type of locks used?

1 Answers  

---

Why we need to use secondry database file? though, we can do same work using primary database file also.

2 Answers   Microsoft,

---

List all types of constraints in sql server?

0 Answers  

---

What is user defined datatypes and when you should go for them?

0 Answers  

---

How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?

2 Answers  

---

---

What are the types of normalization?

0 Answers  

---

How to create a ddl trigger using "create trigger" statements?

0 Answers  

---

What is the purpose of sql profiler in sql server? : sql server database administration

0 Answers  

---

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

0 Answers  

---

How to retrieve range of 10th rows to 20 th rows from total rows from a database table.? (Not from Dataset)

10 Answers   Cognizant, Infosys,

---

Explain filtered indexes benefits?

0 Answers  

---

what is dbcc? : Sql server database administration

0 Answers  

---