Viewing 10 posts - 1 through 10 (of 10 total)
RonKyle (3/25/2014)
Yes. When comparing very large data sets, your example would perform poorly. See my earlier post for more details.
I personally have found this method to be very fast....
March 25, 2014 at 2:24 pm
FootyRef (3/25/2014)
March 25, 2014 at 2:18 pm
FootyRef (3/25/2014)
I get the same result doing this simple query:select *
from #source
except
select *
from #target
Am I missing the purpose of this demonstration?
Yes. When comparing very large data sets, your example would...
March 25, 2014 at 1:58 pm
a.guillaume (3/25/2014)
The join between #source and #Target in the SELECT .... EXCEPT is not essential
You can obtain the same result with a best cost
SELECT .[ID]
...
March 25, 2014 at 7:41 am
jim.drewe (2/26/2014)
February 26, 2014 at 2:46 pm
"Nice article.
A couple of notes. You state that the plan is read from right to left. That's not completely true. The logical processing order of the plan is from left...
February 25, 2014 at 6:55 am
"This is the first time I have ever seen practical and really meaningful advise about the "black art" of query optimization. The timing is perfect because I need to do...
February 25, 2014 at 6:23 am
"Is there a way to determine memory granted to query just before execution and the actual memory it used during runtime. Can we get this information from execution plans. "
You...
February 20, 2014 at 11:14 am
"If an object in the query does not exist, the validation fails and no estimated plan is created"
If you try to create an estimated execution plan in this case,...
February 20, 2014 at 11:08 am
Thanks for the clarifications, Grant. After researching available material on execution plans, I can appreciate the amount of work that you had to put in to write your book. It...
February 20, 2014 at 10:57 am
Viewing 10 posts - 1 through 10 (of 10 total)