I have some tables on my SQL Server database that I only run inserts / updates nightly from our services and they are Read-only during the day for our clients (there is no update / insert / delete from the end user).
What is the best way I can setup / config this table so that that I can I have these inserts / updates faster at night (while no "client" uses our service) and faster reads during the day (when clients actually use the table for read purposes) ?
These tables are over 100m rows.
Asked by beto
(1 rep)
Sep 24, 2022, 03:56 AM
Last activity: Sep 27, 2022, 09:35 AM
Last activity: Sep 27, 2022, 09:35 AM