Despite that... there's a lot of good information on this thread.:D

It's a tail yank, Brandie... someone who hates East Indians and is trying to give them a bad name. It would appear that was the whole intent of the...

Look for CHAR(13) carriage return or CHAR(10) line feed.

Then it all worked out!...

I'm hoping it's just a tail yanking... dunno if it killed the thread or not... we'll see... heh, like everything else, "It Depends". 😛

Yeaup... I absolutely agree that things like GROUP BY and by making sure that the triangular joins make very small triangles can be very effective. Still, it's something to...

You just shouldn't put an ORDER BY in a view... what if someone wants it in a different order... lots of wasted clock cycles.

Heh... didn't mean too push the sponsor... and I wouldn't have if I never used it. :hehe:

Set up a million row test like I taught you...

Mark Markov (4/17/2008)

---

WOW!!!!!!!!!!!!

I came back here today and was amazed to find 31 pages of responses! I could never imagine that my post would be so popular!

Here's an update on...

REDGATE SQL COMPARE

Do they look as bad as the sprocs found in SQL Server? I was amazed at how cruddy some of them are... sp_SpaceUsed is one of my favorites to...

No, no... the following makes it a triangular join even in the presence of a GROUP BY...

...

It very well could be SharePoint... in which case, it wouldn't be a "fault"... it would be a "feature" 😛

Even if it is related to SharePoint, I suspect the problem...

Hoo boy! That's one of the things I've not liked about CLR's since I first heard of them... people doing things they shouldn't be doing to/from the database...