MS SQL Server Views Question:
Download Job Interview Questions and Answers PDF
Explain What are partitioned views and distributed partitioned views?
Answer:
Partitioned views allow data in a large table to be split into smaller tables. These small tables are called as member tables. The split is done based on range of data values in one of the columns.
In a distributed portioned view, each member table is on a separate member server. This means that the member tables are distributed. To locate these tables easily, the database name on each server should be same.
In a distributed portioned view, each member table is on a separate member server. This means that the member tables are distributed. To locate these tables easily, the database name on each server should be same.
Download SQL Server Views Interview Questions And Answers
PDF
Previous Question | Next Question |
What are views? | Can you explain What is Indexed view? How to create it? |