Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?

3 Answers   Accenture,

---

Explain indexes disadvantages?

0 Answers  

---

What are the encryption mechanisms in sql server?

0 Answers  

---

Can we use custom code in ssrs?

0 Answers  

---

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 are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

0 Answers  

---

What is primary key, unique key, and foreign key?

0 Answers  

---

When do u use clustered index and non-clustered index?

3 Answers   IBM,

---

What is sql server programming?

0 Answers  

---

How to use go command in "sqlcmd"?

0 Answers  

---

Find columns used in stored procedure?

0 Answers  

---

What are the recovery models in sql server 2000?

0 Answers  

---