gpatterson

48 reputation

	48 reputation	bio	website		visits	member for	9 months
4 badges		location			seen	Jun 7 at 16:04

8 Actions

Apr 22	awarded	Popular Question
Mar 14	awarded	Supporter
Sep 14	comment	SQL Server does not optimize parallel merge join on two equivalently partitioned tables Thanks Paul! Great information here, and it certainly addresses the question in detail. We are in a mixed SQL 2008/2012 environment, but I will consider exploring the column-store further for the future. Of course, I still wish SQL Server could effectively leverage a parallel merge join--and the much lower memory requirements it could have--in my use case :) I filed the following Connect issue in case anybody cares to take a look and comment or vote on it: connect.microsoft.com/SQLServer/feedback/details/759266/…
Sep 14	awarded	Scholar
Sep 14	awarded	Student
Sep 14	comment	SQL Server does not optimize parallel merge join on two equivalently partitioned tables Thanks Paul! Great information here, and it certainly addresses the question in detail.
Sep 14	accepted	SQL Server does not optimize parallel merge join on two equivalently partitioned tables
Aug 9	asked	SQL Server does not optimize parallel merge join on two equivalently partitioned tables