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,

---

Does partitioning ssd reduce performance?

0 Answers  

---

Does any body please help me what question's have asked for SSRS in the interview?

0 Answers  

---

I am learning Testing, so i want to learn SQL also because SQL is important for Testing. I want to know which is best Institute in Ameerpet or SR Nagar or any other place in Hyd? Please help me.

7 Answers  

---

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

0 Answers  

---

Can you explain what are various ways to enhance the ssrs report?

0 Answers  

---

Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 Answers  

---

What is the difference between coalesce() & isnull()?

0 Answers  

---

Define master database?

0 Answers  

---

How can we solve concurrency problems?

0 Answers  

---

What is a partitioned view?

0 Answers  

---

Does a sql server 2005 select statement require a from?

0 Answers  

---