Answer Posted / sarika desai

Normalization is a concept of Eliminating data redundancy,
Improve database performance & Index Improvement.

De-normalization is the process of attempting to optimize
the performance of a database by adding redundant data.

Explain the various types of concurrency problem?

1136

---

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1007

---

How do I manually uninstall an instance of sql server 2016?

962

---

Can you explain what is the use of custom fields in report?

1000

---

What is analysis service repository?

968

---

Can primary key be null?

879

---

Explain the properties of sub-query in sql server?

954

---

Explain the difference between clustered and non-clustered index?

870

---

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

894

---

how to define testing of network layers? : Sql server database administration

908

---

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

887

---

When cursors are useful?

1036

---

What are the hotfixes and patches in sql server?

973

---

What is the parse query button used for?

981

---

List the different index configurations possible for a table?

882

---