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.

List out different types of normalizations in sql server and explain each of them?

0 Answers  

---

what's sql server? : Sql server database administration

0 Answers  

---

what is sql server? : Sql server database administration

0 Answers  

---

How to send email from database?

0 Answers  

---

as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

0 Answers  

---

---

What is meant by indexing?

0 Answers  

---

What is normalization according to you and explain its different levels?

0 Answers  

---

how many non clustered index in sql server 2008,2010,2012

2 Answers   Accenture,

---

How to delete duplicate rows?

0 Answers  

---

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

0 Answers  

---

Do you know clustered and non-clustered index?

0 Answers  

---

what is the difference between procedure and function.

4 Answers   Thomson,

---