Excellent question. This is one of the things you have to watch for when converting a query that uses the old style outer joins to the ANSI standard outer...

Excellent article Roy. We are just now starting to look at the possibility of moving to SQL Server 2008. Turns out in the next tools release of PeopleSoft...

Hopefully you also noticed in your reading that a table may only have 1 clustered index. You can learn more about the indexes by using the INDEXPROPERTY. You...

The only answer I can come up with is this; It Depends.

What does it depend on? The application and how it is used. Unfortunately you haven't provided any...

Jeff Moden (5/2/2009)

---

Heh... it could simply be that the non-Ansi join was returning the incorrect row count to begin with. From BOL...

In earlier versions of Microsoft® SQL Server™ 2000,...

A) I...

dave b (5/2/2009)

---

Hello...

I'm hoping that someone can help me calculate a monthly billing total. I'm writing a report where I need to account for a minimum price in the total...

Part of the filter criteria needs to move up to the join criteria. Try this query and compare it to the results of the original.

SELECT DISTINCT

...

Please read the first article referenced in my signature block below.

I did a little more testing and wanted to post the results of the testing. These are in the same order as the queries in my previous post:

CpuMs ...

Now triple posted. Please reply here.

Now triple posted. Please reply here.

With the multiple database solution, you have to be sure that users are "synced" between databases. Using separate schemas and filegroups may actually be easier. To give a...

Then there are the newbie's on the site who get impatient because no one is answering them, so they just start posting in other forums hoping to get a response.

Edit:...

This doesn't look like something you need a constraint for as much as looking at it differently. What you describe fits a design that would use a ValidFrom, ValidTo...