Forum Replies Created

Viewing 15 posts - 586 through 600 (of 673 total)

  • RE: Unique constraint on a nullable column

    :cool:I am giong to get my point I lost back!;-)

  • RE: Unique constraint on a nullable column

    Simple facts:

    This is an Administration question.

    There is no way that any Database Administrator can limit the code being executed against a table to enforce a Unique constraint data requirement.

    Since there...

  • RE: sp_tables

    Nice Question!

    I liked the way I learned something from the answer.

    Never tought before about how it lists System Tables as a TABLE object even though they are...

  • RE: Can the Secondary files in a database be taken offline?

    Great Question.

  • RE: Steve Jones

    I live about 1/2 mile from the BNC Main runway.

    Nashville has so much ambiant noise that we literally use soundproof rooms to make clean recordings.

    Unless you like to...

  • RE: SSIS Execute Package Task

    da-zero (11/18/2010)


    Great question. Luckily I had this right, as I have my 70-448 exam today. If I got it wrong, I would've panicked. 🙂

    Good question. After five plus years...

  • RE: Data Typing Quandry

    Robert Davis (11/18/2010)


    UMG Developer (11/18/2010)


    Contrary to popular beliefs, I don't sit around all day waiting for someone to post comments. In reality, I was up at 3 AM on the...

  • RE: Data Typing Quandry

    da-zero (11/18/2010)


    SanDroid (11/17/2010)


    We would prefer your respect for the effort that the author has made to create a question so that people could learn about compression, instead of calling it...

  • RE: SELECT INTO with a Temp Table

    I also was one that selected the right answer because thier where so many errors in the code I determined that was either the right answer, or the one most...

  • RE: Data Typing Quandry

    Hugo Kornelis (11/17/2010)


    So please stop this babbling about a perceived ambiguity, the question is perfectly clear.

    All regulars know that I won't hesitate te criticise a question that I feel does...

  • RE: Data Typing Quandry

    UMG Developer (11/17/2010)


    I couldn't find any definition for "defined row size", do you have a link to a definition? Does it include metadata?

    Exactly my point. The term in the question...

  • RE: Data Typing Quandry

    UMG Developer (11/17/2010)


    mtassin (11/17/2010)


    I agree. I got this wrong for the same reason. The Row Size doesn't change, compression just lets more data be stored on a page.

    But...

  • RE: Data Typing Quandry

    chrs-513176 (11/17/2010)


    I was thinking along the same path, although I thought it still was a good question because I did learn something new.

    I had already learned the differance between Defined...

  • RE: Data Typing Quandry

    Disapointing and Lame trick question.

    The question asked which row had the "largest defined row size", not "the largest storage size".

    The answer in the the reference material is for a differant...

  • RE: COALESCE Vs ISNULL

    Nice question. I learned something new about the Coalesce function and NULL values.

    IMO: The actual data type for a NULL value once inserted into a table has to do...

Viewing 15 posts - 586 through 600 (of 673 total)