Forum Replies Created

Viewing 7 posts - 76 through 83 (of 83 total)

  • RE: Why Object Qualification is important.

    Bother. At least I have them running separately through the Job Agent rather than calling each other so I'll only have to change them in one place. Thanks...

    Puto me cogitare, ergo puto me esse.
    I think that I think, therefore I think that I am.

    March 10, 2008 at 9:12 am

    #787428

  • RE: Why Object Qualification is important.

    Out of curiosity, does specifying the 3-part name for a stored procedure (e.g. srienstr.dbo.sp_diabetes) prevent the check of master for procedures with a prefix of 'sp_'?

    Not that I've been foolish...

    Puto me cogitare, ergo puto me esse.
    I think that I think, therefore I think that I am.

    March 10, 2008 at 8:59 am

    #787416

  • RE: Generate index on foreign key columns

    Mike Byrd (3/4/2008)

    There are times when an index is not needed for a foreign key. If the table is small (low number of rows) or the index column has...

    Puto me cogitare, ergo puto me esse.
    I think that I think, therefore I think that I am.

    March 4, 2008 at 12:48 pm

    #785166

  • RE: Generate index on foreign key columns

    Which version of SQL Server is this written for? I've got 2000, and neither the table names nor column names match the system tables.

    Puto me cogitare, ergo puto me esse.
    I think that I think, therefore I think that I am.

    March 4, 2008 at 9:09 am

    #785013

  • RE: Table Variables

    GSquared (1/31/2008)

    The only IT-specific definition of "valid" that I can find in any dictionary online is "A data-flow computer language", in which it is a proper noun.

    If we're dealing with...

    Puto me cogitare, ergo puto me esse.
    I think that I think, therefore I think that I am.

    February 1, 2008 at 8:03 am

    #774228

  • RE: Table Variables

    GSquared (1/31/2008)

    I disagree with the point about the transactions.

    Dictionary definition of "valid": "well based or logical" (Compact Oxford English Dictionary, as referenced on http://www.onelook.com).

    Doing a transaction and rollback on a...

    Puto me cogitare, ergo puto me esse.
    I think that I think, therefore I think that I am.

    January 31, 2008 at 12:53 pm

    #773912

  • RE: Table Variables

    Jon Spink (1/31/2008)

    I chose 'TRUNCATE TABLE' and was told I was wrong, the correct answer is 'TRUNCATE TABLE'...

    I chose the index one, and was also partly right. I too...

    Puto me cogitare, ergo puto me esse.
    I think that I think, therefore I think that I am.

    January 31, 2008 at 8:04 am

    #773758

Viewing 7 posts - 76 through 83 (of 83 total)