Viewing 15 posts - 376 through 390 (of 8,416 total)
GilaMonster (8/22/2012)
No, I meant the one you're posting in. Order by in an insert.
Oh right. I wonder what he'll come up with next on that one.
August 22, 2012 at 3:04 am
GilaMonster (8/22/2012)
Yes, same one, and it's the thread with Paul involved."But it's not the only target people could chase with the statement, would you agree?"
Only involved by blog proxy, so...
August 22, 2012 at 2:18 am
Sergiy (8/21/2012)
The plans are identical for "Query 2" and "Query 3" in SQL 2008 as well.
No they're not. On SQL Server 2005, SQL Server 2008 and SQL Server 2008...
August 21, 2012 at 6:11 pm
dwain.c (8/21/2012)
Can you (or someone) expound on what you mean by "concurrency effects?"
I have encountered a number of very high read workload OLTP systems (web sites) where any changes to...
August 21, 2012 at 4:06 am
dwain.c (8/21/2012)
August 21, 2012 at 3:12 am
Sergiy (8/20/2012)
Order by actually guarantees the order of records as they are inserted into a table.
Not correct. There was a missed optimization pre-2012 which meant that a unnecessary sort...
August 21, 2012 at 2:32 am
codebyo (8/17/2012)
I wonder what you guys use the most: temp tables or table variables in terms of performance.
It depends on the context. Table variables can have significant performance advantages...
August 21, 2012 at 12:47 am
GilaMonster (8/10/2012)
Yes, it went too far. That was doing exactly what we complain about Celko doing - attacking the person not the idea.
+1
August 10, 2012 at 4:19 pm
Grant Fritchey (8/3/2012)
don't quote me
My rebellious side could not resist.
August 3, 2012 at 7:03 am
Jan Van der Eecken (8/2/2012)
Talking rowing, did anyone watch South Africa clinching the Gold Medal in the lightweight fours today?
I did yes! Very impressive.
The whole office was watching and...
August 2, 2012 at 8:28 pm
Fal (8/2/2012)
Well, being a Kiwi he does live in the land of Mordor. 😛
True; see the picture below of two hobbits* winning our first gold medal in the rowing...
August 2, 2012 at 6:24 am
SQLRNNR (7/27/2012)
July 27, 2012 at 8:07 pm
capn.hector (7/27/2012)
well now in the morning im even more embarrassed at the mistake i made.
It was only a small error; I wouldn't dwell too much on it. Focus on...
July 27, 2012 at 8:16 am
David Burrows (7/27/2012)
GSquared (7/27/2012)
Generate and join on Checksum/Hashbytes is probably your best bet.
I thought you had to test equality of the columns as well, as checksum values may not be...
July 27, 2012 at 8:02 am
Viewing 15 posts - 376 through 390 (of 8,416 total)