Ralph Attard
Ralph is an enterprise and data platform architect with over 15 years of hands-on and leading positions. He is a Microsoft Certified Trainer who regularly speaks at a local user-group and at conferences from time to time.
SQLBits 2020
Scaling databases using partitioned views
Walk through partitioning strategies and look into partitioned views to consolidate distributed data. Enterprise features makes this easy, however hacks will be demo'd to make this work in Standard edition.
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.