How to tell sql server the maximum size my temp table will grow so that it
does at most 1 memory allocation?

Linq2Sql issues
DataTable foreign key
prompt user to select from recordset.
Getting a subset of DataRows from a DataTable
vs2008 or not