you might want to allocate a high percentage of the database resources to data warehouse loading jobs at night and allocate a higher percentage of the resources during the day to the application jobs.
To accomplish this, you can change the database resource plan by using a Scheduler window.