http://blogs.msdn.com/craigfr/archive/2008/01/18/partial-aggregation.aspxIn some of my past posts, I've discussed how SQL Server implements aggregation including the stream aggregate and hash aggregate operators. I also used hash aggregation as an initial example in my introductory post on parallel query execution . In thisenCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/craigfr/archive/2008/01/18/partial-aggregation.aspx#8397706Tue, 15 Apr 2008 18:01:00 GMT91d46819-8472-40ad-a661-2c78acb4018c:8397706EXEC dbo.LongTermMemory__Archive<p>There are many myths surrounding table variables and one of the most common is probably the 'in memory'</p>