Viewing 15 posts - 2,191 through 2,205 (of 6,036 total)
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...
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...
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...
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...
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...
August 26, 2012 at 6:13 pm
SQL Kiwi (8/24/2012)
August 26, 2012 at 6:02 pm
SQL Kiwi (8/24/2012)
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...
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...
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...
August 23, 2012 at 10:09 pm
GSquared (8/22/2012)
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...
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...
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...
August 21, 2012 at 5:51 pm
GilaMonster (6/2/2012)
Order by on an insert has never been guaranteed to do anything other than control the order of the identity column if present
Not correct.
Order by actually guarantees the order...
August 20, 2012 at 9:32 pm
Viewing 15 posts - 2,191 through 2,205 (of 6,036 total)