Forum Replies Created

Viewing 15 posts - 1,546 through 1,560 (of 6,486 total)

  • RE: What Node am I on?

    Richard M. (1/18/2010)

    Matt, I am not sure how you would state that the result depends on where it is being run from.

    As per BOL:

    ComputerNamePhysicalNetBIOS

    NetBIOS name of the local...

    January 18, 2010 at 9:47 am

    #1105013

  • RE: What Node am I on?

    Adi Cohn-120898 (1/18/2010)

    Matt Miller (#4) (1/15/2010)

    Seth Lynch (1/15/2010)

    Spot on 😛

    Thank-you

    Seth

    .

    Keep in mind that may execute under the service account context, which could show you the location of the IIS server...

    January 18, 2010 at 8:15 am

    #1104956

  • RE: Subroutines in TSQL

    Jeff Moden (1/17/2010)

    Ummmm.... where do you see a GOTO in any of that? 😉

    I didn't.

    I'm saying that most OO languages these days would tend to do branching in...

    January 17, 2010 at 11:08 am

    #1104720

  • RE: calling a temp table from within a sproc

    winston Smith (1/17/2010)

    CirquedeSQLeil (1/15/2010)

    Winston,

    Try doing it as Jeff has just explained. Create multiple procs, from one of which you will call the other. I think that will probably...

    January 17, 2010 at 11:05 am

    #1104719

  • RE: Subroutines in TSQL

    Jeff Moden (1/16/2010)

    Understood and we already have that (it's what I meant when I said it sounds like a cursor)... it just doesn't need to be inline...

    --= some very high...

    January 16, 2010 at 9:20 pm

    #1104663

  • RE: Physical and Logical Ordering of an index

    When there IS a clustered index, the physical data is stored in the clustered index. So the leaf level of a CLUSTERED index = the actual record. Any...

    January 16, 2010 at 8:42 pm

    #1104658

  • RE: The Price of SQL Server

    Andy Warren (1/15/2010)

    I don't think the prices are bad or out of line, especially since we've gotten some nice gains with the multi core stuff essentially for free. One thing...

    January 16, 2010 at 10:53 am

    #1104618

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (1/16/2010)

    I guess that Twitter SQL help thing is going to work out great, isn't it?

    Can't help but think that the amount of help you can provide...

    January 16, 2010 at 10:20 am

    #1104609

  • RE: Why experienced DBA try to embraces to younger DBAs in interviews?

    Jeff Moden (1/15/2010)

    I agree with the final conclusion here... only experience can rate experience. Even a Software Development Manager may not know enough to interview a DBA candidate to...

    January 15, 2010 at 7:51 pm

    #1104537

  • RE: What Node am I on?

    Seth Lynch (1/15/2010)

    Spot on 😛

    Thank-you

    Seth

    .

    Keep in mind that may execute under the service account context, which could show you the location of the IIS server serving up the page, and...

    January 15, 2010 at 11:57 am

    #1104384

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (1/10/2010)

    Paul White (1/10/2010)

    Alvin Ramard (1/9/2010)

    Hey, that gave me an idea. Maybe we should all add our phone numbers to our signature.

    Indeed. i was thinking of an 0900...

    January 10, 2010 at 12:39 pm

    #1101547

  • RE: How do you limit records using Distinct and Count - TOP and Rowcount dont work ?

    Obscure help for an unclear question. Try this hints game:

    from BOL on the TOP clause:

    Specifies that only the first set of rows will be returned from the query result....

    January 10, 2010 at 12:36 pm

    #1101545

  • RE: Women in Technology

    Steve Jones - Editor (1/7/2010)

    Antares686 (1/7/2010)

    Many times pay has nothing to do with fairness, it simply boils down to what you are willing to fight for.

    You are absolutely correct,...

    January 7, 2010 at 8:34 pm

    #1100670

  • RE: Women in Technology

    Phil Factor (1/6/2010)

    . That's like saying we should have more women in the mining industry."

    If we accept the research published by the 'Women in Mining' organization (who would, I'm sure,...

    January 7, 2010 at 7:31 am

    #1100202

  • RE: Business Days using GETDATE()

    Lynn Pettis (1/4/2010)

    mannymendieta (1/4/2010)

    Hi, I meant weekdays. Mon-Fri

    Okay, so based on today (2010-01-04) what would the result of today - 2 be?

    Meaning - if today is a weekday do...

    January 4, 2010 at 2:21 pm

    #1098642

Viewing 15 posts - 1,546 through 1,560 (of 6,486 total)