Viewing 15 posts - 1 through 15 (of 17 total)
testing this the first statement updates 2 rows, the second statement again all rows because m.ID is not a row of the subquery and so does not limit the updates...
October 30, 2024 at 9:17 pm
@steve-2: with your statement same problem, because ts.PKey is not column of subquery.
Must be: Q1.myKey
update ts
set ts.WertA = 'TEST'
from TempSel ts
where ts.PKey in (select...
October 30, 2024 at 5:23 pm
in th example of course I coul do it like
UPDATE TempSel SET WertA = 'TEST' WHERE PKey LIKE '3%';
the selection for the records to update was much...
October 30, 2024 at 2:53 pm
your are right: using a qualifier results in an error (unknown column):
update TempSel set WertA = 'TEST' where PKey in
(select Q1.PKey from (select PKey as myKey...
October 30, 2024 at 2:50 pm
hm .. but why does the optimizer not solve this ?
Is it to me, to control and change the select-Statements ?
April 28, 2015 at 10:28 am
I took a closer look to the execution plans: can't see big differences ... the main Job is the "RID Lookup" with about 70% but very small costs in both...
April 28, 2015 at 8:24 am
script attached ...
some indexes on objkeys are stupid for searching (e.g. okeydata without okeyname / okeyno) but were released by the software vendor;
we added the "KH_..." Indexes for better Performance...
April 28, 2015 at 7:45 am
objkeys has several columns ... we need parentid (key to the object-table), okeyname and okeydata
(okeyname is the Name of the value and okeydata is the value itself,
e.g. okeyname "VENDOR"...
April 28, 2015 at 7:29 am
Server-language is set to: "Deutsch (Deutschland)" / "German (Germany)"
Language in Connection-Property for both database is: "Deutsch (Deutschland)" / "German (Germany)"
April 15, 2013 at 1:02 am
sure .. so break it down:
where can I set the datetime-format for a specific database or database / user / field ?
April 12, 2013 at 12:18 pm
It seems, that MS changed something in the optimization,
maybe it's a bug in 2005R1 - I will check this again after installation of SP3.
Does anyone know if there's a detailed...
December 1, 2010 at 12:52 am
Of course it doesn't appear if there is a full-covered-index.
The problem was broken down, so the DMS-software joins this
table with other tables where some columns can't be included into the...
November 30, 2010 at 9:20 am
sql-plans attached.
the story is going on:
after inactivating the pw_index in the 2005R1,
the SELECT with "=" uses the still remaining index (with "included columns"),
after deleting the pw_index in the 2005R1,
the SELECT...
November 30, 2010 at 6:35 am
sql-plans in attachment ...
How can I delete this post ... ?
November 30, 2010 at 6:06 am
Viewing 15 posts - 1 through 15 (of 17 total)