There will not be enough memory to complete the operation. Since SQL Server is in the business of returning your query results and not throwing errors, it uses TempDB to complete the operation.