Please repost over in the 2000 forum to get 2000 specific help.

Everyone's favorite answer: it depends. If you have an inline function that is returing a table value, it effectively works like a view and the query processor blows out the...

I'm not sure it's a secret, but I can click on the Object Explorer window, say on the "Tables" folder within a database and there it is.

You got it? Cool. It's a neat little trick that I learned from a Microsoft Consultant. It's good to see other people find it useful too.

Yeah. I put it that way in case, like us, you have a compound PK.

I'd stay away from table valued functions unless performance is completely not a concern.

The cross apply should only return a single value such that you'd get more than one row,...

Hmmm. Not an easy one. I looked through the code, I generated the query. Everything looks ok, assuming the data types in the tables are as presented, with one possible...

Sounds like a problem inside the code of the stored procedure. Can you post it?

Assuming a straight SELECT query, at no point should there be a conversion from anything to...

Oh, OK. Well it sounds similar to a problem we have

SELECT ...

FROM p

CROSS APPLY (SELECT TOP 1 ...

...

Wouldn't the EndDate be a "+" 1 to make it a day larger than the EffectiveDate?

Also, I think that you may want to use the DATEADD() function because MS is...

SELECT TOP 1 *

FROM X

ORDER BY Something (ASC/DESC)

The ASC (ascending) will get you the first record, the DESC (descending) will get you the last record. Just remember that TOP processes...

If you've got an existing system, monitor it to see what, if anything, is behaving badly. Start from there. Once you've identified the issues, you can start to make decisions...

I agree with what everyone has written and, since I didn't see it, I'll add one more thing. The reason you have to be so picky about the clustered index...

You can't do that, but there is a filter tool in the Object Explorer and in Object Explorer Details window that will allow you to look at subsets of the...

Stupid question, I know, but is it possible that the SET NOCOUNT ON is, you know, off inside these queries? Depending on how you make the call, I've seen rows...