Answer Posted / padmapriya

Noramalization is process of breaking the information into
well defined tables which should follow some rules. There
are 5 Normal forms available. Each one having a separate
rule.
1NF-Avoid redundant data
2NF-All coulms except primary key column should be related
to the primary key column
3NF,4NF and 5NF - I'dont remember , if any one knows please
reply

Explain about Joins?

981

---

How to view the error log for any specific instance? : sql server database administration

1026

---

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

1061

---

Explain the microsoft sql server delete command?

1012

---

What is difference between delete & truncate commands?

1069

---

what stored procedure can you use to display the current processes? : Sql server administration

1004

---

Can we create clustered index on composite key?

1067

---

What does it mean to invest in the index?

956

---

You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

902

---

What is the data type of time?

959

---

What happens if the update subquery returns no rows in ms sql server?

1117

---

How you can change a cross join into an inner join?

956

---

What is used to replicate sessions between instances in coldfusion clusters?

1062

---

What are trace flags and mention a few common trace flags used with sql server?

1078

---

What are the new features of sql server 2008 r2 reporting service?

209

---