MAX NUMA/ "Affinity" in SQL Server
You could use SQL Server's "processor affinity" to limit processing to a single NUMA node.  See the &lt;process affinity&gt; section of the ALTER SERVER CONFIGURATION command on this MSDN page for more details.

By default, SQL Server attempts to keep query processing contained inside a given NUMA node if the query goes parallel where MAXDOP &lt;= number of cores per NUMA node.  The indication here is to configure MAXDOP to a reasonable value; certainly not more than the number of cores per NUMA node.  There are a load of resources to help with calculating a reasonable MAXDOP; including the answers on my question.