Sample Header Ad - 728x90

SQL server OLAP tables perfomance

0 votes
1 answer
64 views
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