I'm having the same issue. Any help with this would be appreciated.

Good idea. Thanks for the advice. Unfortunately, the issue comes up once ever few months, so it is hard to know for sure if it is resolved. ...

The issue I'm having is that on a SQL 2005 box running Analysis Services 2005, I also want to install the management console for Analysis Services 2000 (so I can...

To recap...is the consensus that using non-fully qualified object names, including for tables, stored procedures, and other objects, will have a performance hit for both SQL 2000 and SQL 2005?

Jereme Guenther (10/25/2007)

---

So what is the advantage of OUTPUT parameters over a standard result set? From my experience they are much more of a pain to deal with both...

Great example, and thanks for the info on the MERGE functionality.  A question about usage...

With this syntax:

WHEN SOURCE NOT MATCHED THEN

        DELETE

Can I put other things in there...

Nice bit of knowledge. My issue would be that there are other factors that could affect the performance of the backup - especially network latency.  We should keep this in...

"Sarcasm or not, this is where you should have made the effort to talk to the end users"

I think something is missing here.  Not every developer has the exposure to...

By checking the square root outside of the select statement, you will save the processor a number of extra calculations.  I modified it to be this:

 SELECT @NextIntSqrt = SQRT(@NextInt)

 IF NOT...

I like the trick for handling the DATEFIRST.  With it, you can write the function in 3 lines without recursion, which I think is a bit more elegant.

CREATE FUNCTION dbo.fnGetNextBusinessDay...

I really liked the script that will traverse the FK hierarchy.  However, it looks like it will only work as long as there is no recursiveness - if a table...