Speaker: Ralph Attard
The first part of this session will explore how vertical and horizontal partition strategies could be queried, updated, and distributed using database views that unify various tables together. Simple views are updateable however more complex views that include derived or constant fields, aggregates, or target multi-table updates would require instead of triggers to make this possible. The second part will look into distributed partitioned views. Linked servers and check constraints will be utilized to retrieve data from multiple servers. Will also show how enterprise edition supports distributed updates natively and how triggers could make it work on standard edition.