New DB: Best settings for a BI staging area
0
votes
1
answer
130
views
I would like to know if there are specific recommended settings when creating a new DB (in SQL Server) which will serve as a staging area DB for BI data flow. In terms of DB use behavior this means:
- quite large tables (from above a mln rows)
- fast growing tables (1-2 mln rows every 4-6 months)
- massive insertion/deletion operation made by ETL
There is something that need to be changed in the default DB properties? Can you specify it carefully?
Thank you
Asked by Gam
(109 rep)
Jun 8, 2022, 10:00 AM
Last activity: Jun 8, 2022, 01:03 PM
Last activity: Jun 8, 2022, 01:03 PM