We're running this in a stored procedure:

SELECT

myFields FROM

OPENROWSET(

'Microsoft.ACE.OLEDB.12.0','Excel 12.0;Database=\\myServer\UploadedFile\WorkLoad_Dist.xlsx', [Sheet1$])

I've also used a direct path to the file system. It works for SA, it works for a...

How can I check the security context? There is no linked server because we;re using openrowset.

I looked at stack - I would think if it was trying to access...

I've run this test previously with similar results. I've attached the execution plan. I removed some columns so that we're just dealing with the view in question.

Thanks! ...

Sorry, I just realized that the fast and slow executions are included in each file. Compare the top one to the bottom one. You can see in the...

That helps but still doesn't explain why the

where IN (sub select)

has such a different execution plan than

WHERE IN (constants)

What I've done to improve the performance (and I'm not really...

Well, I can see the difference. I'm interested in knowing if there's a way to improve it.

When I use a constant in my query, the data is...

Uploaded the two execution plans.

Thanks!

ST

Temp table is a heap with 1 row, 2 columns of int, int.

Looking for how to post an execution plan.

The execution plans are pretty big. I'm not sure how to post them.

I get completely different execution plans between fldValue=123 and fldValue IN (select value from tempTable). I...

Thanks!

ST

I have become aware that my DISTINCT is ignored. My question is why? Is this by design? My real world data contains 100K+ records in each side...

OK, I figured it out. Strange indeed.

The purpose of the query is to determine which parts have not been used in the building of a widget.

My first derived table...

Set the default value for the new field to null.

Modify your delete trigger to only update if the new field value is null:

update myTable set myField = oldValue...

Given that the ROWCOUNT is deprecated I would suggest this solution

-- update 100 rows at a time

-- insure that you are counting rows

SET NOCOUNT OFF

while (1 = 1)

begin

UPDATE...

Another solution could be:

-- Create a table to hold your text value

create table #txt (txt text)

insert into #txt (txt) values('myy value here')

--...