17 – Indexed Views (22m)
When your users frequently run aggregation queries on large amounts of data, and they’re willing to make delete/update/insert (DUI) operations slower in order to get faster reports, you should check out indexed views. Demo script: Transact-SQL /* Indexed Views v1.1 – 2019-04-09 Be aware that in here, you’re going to be making schema changes to […]
To access this incredible, amazing content, you gotta get Recorded Class Season Pass, or log in if you already shelled out the cash.