Building a Static Data Warehouse Server
Duration: 60 minutes
Track: Data Warehousing
Sometimes users require underlying data to be static and unchanging. In this session we'll examine steps used to create a static server from a copy of a live data warehouse server, including implementing clustered columnstore on large partitioned tables, simplifying the management of files and filegroups, and reclaiming large amounts of database space.