Answer / thiyagaraj.ramaswamy

DBCC stands for database consistency checker. We use these
commands to check the consistency of the databases, i.e.,
maintenance, validation task and status checks.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.

Explain log shipping?

0 Answers  

---

How to delete duplicate rows in sql server?

0 Answers  

---

What is normalization and what are the advantages of it?

0 Answers  

---

How will you monitor replication latency in transactional replication? : sql server replication

0 Answers  

---

Your table has a large character field there are queries that use this field in their search clause what should you do?

0 Answers  

---

---

How many full-text indexes can a table have?

0 Answers  

---

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

0 Answers  

---

hi i am having .mdf file and .ldf file ..how can i get the all table in my .mdf..plz give solution

2 Answers  

---

event classes in sql server

2 Answers   Accenture, AFE,

---

Explain Active/Active and Active/Passive cluster configurations?

1 Answers  

---

Explain the benefits of user-defined functions?

0 Answers  

---

How to download and install microsoft sql server management studio express?

0 Answers  

---