Answer Posted / ramesh l.v.

Normalization is the process of efficiently organizing data
in a database. There are two goals of the normalization
process: eliminating redundant data and ensuring data
dependencies make sense

what are the types of indexes? : Sql server database administration

1097

---

What is table constraint?

972

---

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

1038

---

How do I setup a local sql server database?

981

---

How to see the event list of an existing trigger using sys.trigger_events?

1057

---

What is 1nf normalization form?

1016

---

How to replace given values with null using nullif()?

969

---

what are defaults? : Sql server database administration

1069

---

Explain a checkpoint?

1013

---

Suggest a method of joining two tables.

1143

---

How do I run a trace in sql server?

967

---

Can you always create a cache of a report?

172

---

How can you find out how many rows returned in a cursor?

1005

---

Why should you use or avoid select * statements?

1002

---

Mention the differences between substr and charindex in sql server.

1024

---