Oh, I think it's...

Close, try this:

Replace(REPLACE(REPLACE(description, CHAR(13), ''), CHAR(10), ''), CHAR(9), '')

It usually depends on the size of the company and how many databases: If they do not have enough to justify a full-time dba-only, then they will split the job...

Jeff Moden (4/16/2008)

---

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

...

Drop the FK's

And now a word from our sponsors ...

😉

Jeff Moden (4/16/2008)

---

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...

Thanks for the assist, Matt.

Jeff Moden (4/16/2008)

---

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...

Well, the first thing that you have to do is to install Outlook (not Exchange, and not Outlook Express) on the machine that is your SQL Server. If this...

That was just the Where clause. Here is the whole query:

Select *

From stud_mast

WHERE ( month(dob)-2)

...

No, it means that there is no easy fix for that. Sorting/Collation is language & alphabet specific, so you will want a different collation for each different language that...

Building on what Matt said:

I actually think that the whole Parallelism thing is one of the keys to what's going on here with these tests and why your Triangular query...

Typo alert: I think that you missed the ":" and hit the "L" instead.

it means that you are using Mixed authentication mode instead of Windows-only authentication.