Forum Replies Created

Viewing 11 posts - 1 through 11 (of 11 total)

  • RE: Execute Task on Right-Click not available

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

  • RE: Error connecting to SSAS 2000

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

  • RE: Installing Analysis Services

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

  • RE: Why Object Qualification is important.

    To 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?

  • RE: Output Parameters

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

  • RE: The Power of Merge

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

    With this syntax:



    Can I put other things in there...

  • RE: Mirrored Backups

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

  • RE: My Projects Have Never Failed

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

  • RE: Finding Primes

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

  • RE: Finding the Next Business Day Recursively

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

  • RE: Foreign Keys

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

Viewing 11 posts - 1 through 11 (of 11 total)