Archives: March 2010
Cross Apply Ambiguity
Cross apply (and outer apply) are a very welcome addition to the TSQL language. However, today after a few hours of head scratching, I have found an simple issue which could cause big big problems.
What would you expect from this statement ?
select * from sys.objects b…
2 comments, 1,522 reads
Posted in Dave Ballantynes blog on 26 March 2010
Output = MAXDOP 1
It is widely know that data modifications on table variables do not support parallelism, Peter Larsson has a good example of that here . Whilst tracking down a performance issue, I saw that using the OUTPUT clause also causes parallelism to not be used.
By way of example, first lets… Read more
0 comments, 548 reads
Posted in Dave Ballantynes blog on 4 March 2010