what is normalization? what is denormalization?

9 Answers   Satyam,

---

What is dml command?

0 Answers  

---

Which are the olap features?

0 Answers  

---

What does truncate do?

0 Answers  

---

hi. suppose one person goal is strong knowledge on SQL.... suggest me ...if he learns SQL SERVER or ORACLE? which is best?

7 Answers   Google, TCS, Unisys,

---

---

Tell me what is use of except clause? How it differs from not in clause?

0 Answers  

---

how to know description of a table in sqlserver 2000

8 Answers  

---

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

0 Answers  

---

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

0 Answers  

---

Explain what are the basic functions for master, msdb, model, tempdb databases?

0 Answers  

---

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

0 Answers  

---

What are the Advantages of using CTE in sql server?

0 Answers   Winsol Solutions,

---