Viewing 15 posts - 2,821 through 2,835 (of 8,416 total)
Very interesting. Blogged about it.
http://sqlblog.com/blogs/paul_white/archive/2010/08/04/another-interesting-merge-bug.aspx
August 4, 2010 at 12:01 am
GilaMonster (7/29/2010)
He's acted that way just about each time I've disagreed with him. Got almost an 'I told you so!' feeling from him on reply.
Hmmm. I don't think...
July 29, 2010 at 10:14 am
Brandie Tarvin (7/29/2010)
DOH. Sorry. :pinch:
No worries! It gave me a laugh, and it's all good information, so only good things happened 🙂
July 29, 2010 at 8:21 am
Brandie,
LOL! Yes I know how tail-log backups work and what they're for 😛
I've just never actually tried it with a *damaged* simple-recovery database, which is the only case I...
July 29, 2010 at 8:05 am
Jeff Moden (7/29/2010)
Heh... I AM curious why you'd show someone how to shoot themselves in the face once they've told you that they have a loaded gun.
Um, I was bored?...
July 29, 2010 at 7:20 am
Tom.Thomson (7/29/2010)
Amazing, especially the one from someone who's apparently an MVP.
I'm sure we've all said dumb stuff at times, but reading that thread there seemed to be a strange reluctance...
July 29, 2010 at 7:17 am
sporoy (7/29/2010)
I guess it is about the inner workings of TOP statement, why should one chooses to scan entire table, although it is possible with 1 index seek?
Let me have...
July 29, 2010 at 6:49 am
ALZDBA (you must let me know your real name at some point :-))
Paul White NZ (7/29/2010)
July 29, 2010 at 5:55 am
Chris Morris-439714 (7/29/2010)
No worries Paul I could see you were in deep water there, mate 😀
:laugh: :laugh: :laugh:
July 29, 2010 at 5:45 am
ALZDBA (7/29/2010)
btw Paul: Nice series on execution plans at sqlblog :smooooth:
Thanks! :blush:
Did you see my edit?
July 29, 2010 at 5:06 am
select *
from reports..titles t
cross
apply dbo.split(t.actors, '|', t.title_id) alias;
Please...please...don't use multi-statement user defined functions if you value performance at all. Use Jeff's split...
July 29, 2010 at 4:58 am
ALZDBA (7/29/2010)
Just double checking we're testing with the correct engine version. (some still use sql6.5/sql7.sql2k 😉 )
Indeed even without the order by the...
July 29, 2010 at 4:39 am
jolan.mahinay (7/29/2010)
HELLO SIR I TRIED TO RUN YOUR QUERY BUT IT HAS AN ERROR.. THIS ARE THE ERROR ON THAT QUERY
No error. It is written for SQL Server 2008,...
July 29, 2010 at 4:23 am
ALZDBA (7/29/2010)
are you actually on SQL2008?
Optimiser behaviour with a row goal is the same on 2005.
what's the fragmentation rate of your table / indexes?
The optimiser does not directly care about...
July 29, 2010 at 4:21 am
Viewing 15 posts - 2,821 through 2,835 (of 8,416 total)