How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

0 Answers  

---

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

0 Answers  

---

Can we write ddl in trigger?

0 Answers  

---

How to know the NAME of the Database and SIZE of the Database at the client node in Sql Server 2005

1 Answers  

---

What is the use of DBCC commands?

4 Answers   NA,

---

How to delete existing triggers using "drop trigger"?

0 Answers  

---

what is the difference between delete,drop and truncate

2 Answers   Honeywell, Zomato,

---

If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?

3 Answers  

---

How will you go about resolving deadlocks?

0 Answers  

---

Explain the ways to controlling cursor behavior?

0 Answers  

---

how to determine the service pack currently installed on sql server? : Sql server database administration

0 Answers  

---

What are different types of Keys? Please explain all the keys with a suitable example.

4 Answers  

---