lucassouzace,
You should read the previous posts in this thread. A number of people thought the 'correct' answer was wrong or the question did not have a single answer.
I am happy to accept that the 'correct' answer will simulate memory pressure, but I am also certain the 'correct' answer is not the right way to troubleshoot a problem with a 1TB table.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara