Setting memory limits for ENABLE_JOIN_SPILL
We have a SQL query that takes upto 30GB of memory and runs for 20 minutes without the ENABLE_JOIN_SPILL and approx. 2 GB and 2 hours when the ENABLE_JOIN_SPILL is turned on. Is it possible to change the memory requirements when a query runs with the ENABLE_JOIN_SPILL turned on? We would like to bump it up to balance out speed and memory consumption.