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,

---

What is equi join with example?

0 Answers  

---

What are the benefits of normalization?

0 Answers  

---

What’s the distinction between dropping a info and taking a info offline?

0 Answers  

---

i need some interview questions on sql server developer plz any onee send some links.

2 Answers  

---

---

What are the differences between DDL, DML and DCL in SQL?

0 Answers   ABB, Aspire, Infogain,

---

How many types of attribute relationships are there? : sql server analysis services, ssas

0 Answers  

---

What is updatable resultset?

0 Answers  

---

Explain what is public role in sql server?

0 Answers  

---

How do you rebuild an identity column?

0 Answers  

---

what are database files and filegroups? : Sql server database administration

0 Answers  

---

what is the different types of backups available in sql server? : Sql server database administration

0 Answers  

---