That is an error in the article! This is wrong:

For large databases, do not use auto update statistics. Update statistics via maintenance jobs instead. I recommend the following...

Again, I'm giving you the same lame answer: I'm repeating the recommendations from  Microsoft black belt team.
I have not analysed memory consumption by the OS on our servers...

To be honest, I'm passing on the recommendation about not locking pages in memory from Microsoft black belt team.
I haven't tested performance with and without this policy. I doubt...

Hi Kenneth.
1: Optimize for ad-hoc workloads recommendation is general, has nothing to do with the size of databases.
2: Nothing wrong with using older compatibility modes as long as...