Explain What are partitioned views and distributed partitioned views?
Submitted by: AdministratorPartitioned 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online MS SQL Server Views Job Interview Questions And Answers
Top MS SQL Server Views Questions
☺ | Explain Indexed view? |
☺ | What are views? |
☺ | Explain the functionalities that views support? |
☺ | Can you explain What is Indexed view? How to create it? |
☺ | Explain What are partitioned views and distributed partitioned views? |
Top New MS SQL Server Categories
☺ | SQL Server Database Administrator Interview Questions. |
☺ | SQL Server Service Broker Interview Questions. |
☺ | SQL Server Locks Interview Questions. |
☺ | SQL Server Constraints Interview Questions. |
☺ | MS SQL Data Mining Interview Questions. |