Viewing 15 posts - 2,191 through 2,205 (of 6,037 total)
SQL Kiwi (8/26/2012)
Sergiy (8/26/2012)
Was not so clear to me, as it turns out. Learned couple of things here, thanks to the good samaritans.
Good. Well the last (important) thing...
_____________
Code for TallyGenerator
August 27, 2012 at 8:36 pm
SQL_path (8/27/2012)
GSquared (8/24/2012)
Same as any other table.and should i drop the ## table in sp2 and sp3 both?
Generally the good practice is to drop objects within the same procedure where...
_____________
Code for TallyGenerator
August 27, 2012 at 1:28 pm
SQL Kiwi (8/26/2012)
"Say we are 'updating' from 'tom' to 'tom'; how do you know that the storage engine doesn't simply...
_____________
Code for TallyGenerator
August 26, 2012 at 8:59 pm
SQL Kiwi (8/24/2012)
Sergiy (8/23/2012) No-one is arguing against the idea that SQL should be written to only affect records that need updating. That is obvious.
Are you sure? Why?
It was...
_____________
Code for TallyGenerator
August 26, 2012 at 6:46 pm
MissTippsInOz (8/24/2012)
Such passion for our topic!!
Be passioned about what you do should be a good thing, right?
🙂
It amused me to note that the original poster announced he'd got the...
_____________
Code for TallyGenerator
August 26, 2012 at 6:28 pm
SQL Kiwi (8/24/2012)
The storage engine sets the is_dirty bit when it changes a page.
If you'd only understand your own words...
:hehe:
Check the lock applied during the transactions.
They are all ROW...
_____________
Code for TallyGenerator
August 26, 2012 at 6:13 pm
SQL Kiwi (8/24/2012)
_____________
Code for TallyGenerator
August 26, 2012 at 6:02 pm
SQL Kiwi (8/24/2012)
_____________
Code for TallyGenerator
August 26, 2012 at 5:56 pm
SQL Kiwi (8/23/2012)
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...
_____________
Code for TallyGenerator
August 26, 2012 at 5:51 pm
SQL Kiwi (8/23/2012)
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...
_____________
Code for TallyGenerator
August 23, 2012 at 11:43 pm
SQL Kiwi (8/22/2012)
I've been trying to work out why you're getting so excited about all this. Perhaps you are wondering whether an update to the same value is actually...
_____________
Code for TallyGenerator
August 23, 2012 at 10:09 pm
GSquared (8/22/2012)
_____________
Code for TallyGenerator
August 23, 2012 at 9:27 pm
SQL Kiwi (8/21/2012)
No they're not.
OK, I'm really curious what's going on behind the scene.
I managed to get identical plans on 2008 as well.
And different plans for the same queries...
_____________
Code for TallyGenerator
August 23, 2012 at 9:24 pm
GilaMonster (8/21/2012)
Order by on an insert does not guarantee the order of the rows in the table
Nothing actually can guarantee the order of the rows in the table. Not even...
_____________
Code for TallyGenerator
August 21, 2012 at 5:57 pm
The plans are identical for "Query 2" and "Query 3" in SQL 2008 as well.
Did you run those queries repeatedly, as I asked?
So we can see the plans for "Query...
_____________
Code for TallyGenerator
August 21, 2012 at 5:51 pm
Viewing 15 posts - 2,191 through 2,205 (of 6,037 total)