Viewing 4 posts - 1 through 4 (of 4 total)
Hi Uwe,
Yes you understood my question correctly and thanks for the explanation.
One further question, how does one calculate the no. of bytes used up by CI/NCI. In our case CI=13...
August 25, 2014 at 11:41 pm
Hi,
So if we make Code Nullable should not the query become non-sargeable, thereby meaning it does not use the Index ix_CCode, but making the column as Null still uses the...
August 25, 2014 at 10:45 pm
what does this do:
UPDATE P
SET P.Specialty = T.Specialty
FROM SomeTable P
INNER JOIN temp T
ON P.id = T.id
WHERE P.Specialty <> T.Specialty
July 9, 2010 at 3:08 am
Viewing 4 posts - 1 through 4 (of 4 total)