Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

0 Answers   iSoft,

---

how to delete duplicate rows from table

9 Answers   CSC,

---

Define synonym?

0 Answers  

---

Without Using Cursors , How to Select the Selected row??

3 Answers   CarrizalSoft Technologies, Wipro,

---

How to Update from select query in sql server?

0 Answers  

---

---

What is the most common trace flags used with sql server?

0 Answers  

---

What is measure group, measure? : sql server analysis services, ssas

0 Answers  

---

What are key constraints?

0 Answers  

---

In what version of sql server were synonyms released?

0 Answers  

---

How to use group functions in the select clause in ms sql server?

0 Answers  

---

Can I recover a damaged SQL Server 2008 database with the undamaged .mdb and .ldf files?

3 Answers   Apple,

---

Advantages and disadvantages of stored procedures.

2 Answers   HCL,

---