Scaling Databases Using Partitioned Views

Speaker: Ralph Attard

Level: 400

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.

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.