Viewing 15 posts - 346 through 360 (of 8,416 total)
ChrisM@Work (8/23/2012)
This does just that:
SELECT
ItemID = ROW_NUMBER()...
August 24, 2012 at 6:09 am
ChrisM@Work (8/24/2012)
August 24, 2012 at 5:28 am
Usman Butt (8/24/2012)
August 24, 2012 at 3:31 am
ChrisM@Work (8/23/2012)
Your technical lead might fare better as a fiction writer - almost all of this statement is incorrect.
Correct Chris. That is quite scary.
August 24, 2012 at 2:47 am
ChrisM@Work (8/24/2012)
A recent thread gives some indication of how democratised functionality can go horribly wrong.
Crikey.
August 24, 2012 at 2:46 am
ChrisM@Work (8/24/2012)
August 24, 2012 at 2:09 am
Usman Butt (8/24/2012)
August 24, 2012 at 2:03 am
Usman Butt (8/24/2012)
SQL Kiwi (8/23/2012)
ChrisM@Work (8/23/2012)
UNION ALL SELECT NULL -- eliminated by CROSS APPLYThe NULL is not eliminated by the CROSS APPLY.
I will second that CROSS APPLY will...
August 24, 2012 at 1:58 am
Sergiy (8/16/2012)
Like I said from the beginning, it's the storage engine (I name it CHECKPOINT, probably not the best choice of word)...
Probably not the best choice of word? Well,...
August 24, 2012 at 12:36 am
Sergiy (8/23/2012)
August 24, 2012 at 12:30 am
Sergiy (8/23/2012)
OK, I'm really curious what's going on behind the scene.
Let me explain. In an update query, the optimizer considers sorting the incoming rows into index order. Sorting...
August 23, 2012 at 11:39 pm
Sergiy (8/23/2012)
The question was: "Does an UPDATE query overwrite existing values if the already existing value is the same as the one your updating with?
I think the questioner was more...
August 23, 2012 at 11:25 pm
Sergiy,
A transaction is indeed started and an exclusive lock is taken in preparation for an update, but how do you know for sure that the page is actually written to?...
August 23, 2012 at 11:19 pm
ChrisM@Work (8/23/2012)
UNION ALL SELECT NULL -- eliminated by CROSS APPLY
The NULL is not eliminated by the CROSS APPLY. You can increase efficiency a little by excluding the NULL with...
August 23, 2012 at 8:43 pm
mburbea (8/22/2012)
August 23, 2012 at 8:33 pm
Viewing 15 posts - 346 through 360 (of 8,416 total)