As discussed in HSEARCH-1367 : it seems that when loading a list of entities by primary key is slow on SQL Server 2008 when the key is composite.

It was reported that we generate a more efficient SQL statement for Oracle, and that this SQL Server version actually would support this same syntax and this would fix the performance problem.

See linked issue for all details.