Forum Replies Created

Viewing 15 posts - 4,546 through 4,560 (of 5,590 total)

  • RE: Trigger Update

    am-244616 - when you select into a variable from a table, the variable is going to hold the value from the last row selected. It might be the first...

  • RE: SP says it's exceeded nesting level when there is no nesting involved!

    CirquedeSQLeil (4/1/2010)


    Congrats on finding the issue.

    This would be a nice example of a bad loop.

    Bad loop indeed. Hmm, what would be a good loop? :w00t:

  • RE: The Missing Certification

    Luke L (4/1/2010)


    CirquedeSQLeil (4/1/2010)


    So we have the model by PMP as one suggestion.

    Anybody have anymore suggestions as to models to research and potentially emulate?

    I think the direction the conversation needs...

  • RE: The Missing Certification

    CirquedeSQLeil (4/1/2010)


    I think these types of questions that get deeper into the subject certainly are what is needed at a higher level certification. This type of certification is kind...

  • RE: The Missing Certification

    Michael Meierruth (4/1/2010)


    So what was the purpose of this discussion on 'table scan vs clustered index scan'.

    That discussion evolved from a comment being made about someone not thinking that an...

  • RE: The Missing Certification

    CirquedeSQLeil (3/30/2010)


    If any are interested, I posted my blog on the topic. A greater bit of depth needs to be done with the topic. I figure this is...

  • RE: The Missing Certification

    dma-669038 (3/30/2010)


    I am writing to Kevin Kline tonight to ask for input on the previous attempt that Gail mentioned. Am going to copy Lynn but if anyone else wants to...

  • RE: Are the posted questions getting worse?

    I've got a theory about Paul... I think he has cloned himself. He then sends his clone out to "go forth and find all good sql nuggets", and then does...

  • RE: The Missing Certification

    Paul White NZ (4/1/2010)


    Anyone giving an answer like that is clearly an insufferable nerd and of no practical use to anyone! :w00t:

    LOL!

  • RE: No More NULL

    I think that the NULL / NIL would be interesting...

  • RE: The Missing Certification

    Paul White NZ (4/1/2010)


    They might be exactly the same thing IF (the execution plan specifies ordered:false to the storage engine) AND (the effective isolation level is read uncommitted OR a...

  • RE: No More NULL

    Ralph Hightower (4/1/2010)


    Ah Steve,

    You had to spoil the joke with a disclaimer.

    Of course, this is also an April Fool's joke and is in no way based on reality. It's entirely...

  • RE: How to find number in series is not entered in table

    You might want to check out this recent thread (click here). It seems to be very similiar to what you are asking.

  • RE: The Missing Certification

    GilaMonster (3/31/2010)


    WayneS (3/31/2010)


    dma-669038 (3/31/2010)


    One guy i talked to did not know the difference between table scan and index seek except that 'it ran faster')

    Makes me wonder what he thinks the...

  • RE: DBCC Timewarp

    Man, that was a lot of points for this question!

    Happy April Fools!

Viewing 15 posts - 4,546 through 4,560 (of 5,590 total)