Very Good Tips on S2k8 64-bit Query Optimization

I was reading this tip on MS SQL Tips by Matteo Lorini and I wanted to pass along the link to it. Matteo has called out a very interesting catch in the 64-bit version of SQL Server 2008 query optimizer whereby he found that SQL Server needed to be fooled into thinking that a row size was large enough to allocate more memory for the query. Otherwise, SQL Server was going to have to perform I/O with R/W to Temp DB. Nice catch!