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,

---

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

0 Answers  

---

What is the osql utility?

0 Answers  

---

What are indexes? When do you need to create Indexes?

4 Answers   CarrizalSoft Technologies, HP,

---

How to generate create function script on an existing function?

0 Answers  

---

---

how to trace the traffic hitting a sql server? : Sql server database administration

0 Answers  

---

What is nolock hint in sql server 2008

0 Answers   HCL,

---

What is autocommit mode in sql server?

0 Answers  

---

What is sql server used for?

0 Answers  

---

How to get number of days in a given year?

4 Answers   ADP,

---

Define normalisation?

0 Answers  

---

What is the use of floor function in sql server?

0 Answers  

---