63 reputation
5
bio website
location
age
visits member for 2 years, 1 month
seen Jul 1 at 15:34

Jul
1
comment Does SQL Server allow INSERTs into tables and indexes to be written in parallel?
Thanks for the thorough discussion. The new SQL 2014 SELECT INTO parallelism is interesting. It would certainly be useful to have that parallelism capability expanded to handle INSERT...SELECT in parallel as well, at least in cases with TABLOCK where minimal logging is enabled.
Jul
8
awarded  Nice Question
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