Answer Posted / radhakrishnan vaithilingam

Dw:historical data for related application and this is
support to decision making system.

Eg: sales manager check the total sale details for all
loaction. every location using seperate database. so we
need to merge all data in one database.

- we can use star schema or snowflake shema

OLAP : online analtical processing.

what are different types of raid configurations? : Sql server database administration

1097

---

what's new in sql server 2016?

1003

---

Do you know what are pages and extents? : SQL Server Architecture

1035

---

What is save transaction and save point?

1255

---

Mention the different types of replication in sql server.

1068

---

What is the difference between for auto and for nested?

1062

---

Does sql server use t sql?

1071

---

How many replicas are maintained for each sql azure db?

124

---

Explain primary key in sql server?

1072

---

What factors you will consider calculating the storage requirement for that view?

990

---

Explain sub-query?

1009

---

Tell me what do you understand by a view? What does the with check option clause for a view do?

1059

---

where can you add custom error messages to sql server? : Sql server administration

1172

---

How to transfer a table from one schema to another?

1045

---

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1244

---