• If you want to enable the T1118 flag in SQL Express there is nothing stopping you from doing so.

    However, because SQL Express (SQL2008 upwards) has a maximum database size of 10GB, can only use 4 CPU cores and a maximum of 1GB RAM, it is unlikely you will ever have the issues that T1118 is designed to overcome.

    You would then have the (small) disk space disadvantage inherent in T1118 without the ability to take advantage of the concurrency improvements that T1118 gives.

    As Gail says, you should test to see if this is beneficial in your environment

    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