Viewing 12 posts - 46 through 57 (of 57 total)
The journey to the execution plan was a result of the first comment.
My initial re-write is close to what I would want for general purposes:
I want the jobs...
December 21, 2011 at 10:50 am
The left joins were used to match the execution plan of the original query I was able to dig up. I tested both with and without the where clause...
December 20, 2011 at 1:42 pm
PO_Type is appears to be 0 for a regular order and 1 for a quote. [AFAIK It should be one or the other. However, the database design, does...
December 20, 2011 at 9:42 am
Yep. I noted that they all turned into inner joins in the execution plan. To get the execution plans to match both with and without the where clause,...
December 20, 2011 at 7:18 am
Looks like this is it....
from Job j with(nolock)
inner join Job_Operation jo with(nolock) on j.Job = jo.Job
inner join [Source] s with(nolock) on jo.Job_Operation = s.Job_Operation
left outer join PO_Detail pod with(nolock) on...
December 19, 2011 at 12:18 pm
Where condition was missing in my rewrite in the original post...
from Job j with(nolock)
inner join Job_Operation jo with(nolock) on j.Job = jo.Job
left outer join Source s with(nolock) on jo.Job_Operation =...
December 19, 2011 at 11:33 am
The database & schema are not mine per se -- It is from a commercial ERP system that we own licenses to and it primarily uses Crystal Reports (no SSRS)...
December 18, 2011 at 2:32 pm
I will give that a go again...
Thanks
December 16, 2011 at 3:06 pm
mohammed moinudheen (8/23/2011)
eric_van_uden (8/23/2011)
[font="Courier New"]Msg 911, Level 16, State 1, Line 1
Database 'test2'...
August 23, 2011 at 4:44 am
From the referenced article...
Transparent data encryption (TDE) performs real-time I/O encryption and decryption of the data and log files. The encryption uses a database encryption key (DEK), which is stored...
August 11, 2011 at 5:57 am
Viewing 12 posts - 46 through 57 (of 57 total)