Forum Replies Created

Viewing 15 posts - 436 through 450 (of 673 total)

  • RE: ROWGUIDCOL

    Tom.Thomson (3/8/2011)


    The right answer of course is "each of them can (but only one at a time)" so of the options provided 3 is closest to correct. 1 (the...

  • RE: ROWGUIDCOL

    Great question. Easy is nice for many reasons.

    I can't be the only one appreciating the easy questions on Fat Tuesday.

    I wonder if the 5% that answered 0 thought...

  • RE: Table Design

    Jamie Longstreet-481950 (3/7/2011)


    Jamie - It was my understanding that this question was about how data is stored in the data pages. What did you see that made you think about...

  • RE: Table Design

    Great Monday Morning QOTD. Thank you.

  • RE: Table Design

    Jamie Longstreet-481950 (3/7/2011)


    This is a good question because it shows just how naive the SQL system can be when it comes to query optimization.

    Jamie - It was my understanding...

  • RE: Visual Studio Database Tools

    Not you...

    Self councious maybe describes you? 😛

  • RE: Visual Studio Database Tools

    blah blah self serving blah

    :discuss::exclamation::Wow:

  • RE: Resource Governer

    Thanks for the good question.

    It actualy made me read the documentation on this view and learn something about Resource Governer, how it works, and what the system runs...

  • RE: Resource Governer

    CirquedeSQLeil (3/2/2011)


    Here is the link that has the info on the default values for those fields.

    http://msdn.microsoft.com/en-us/library/bb934197.aspx

    That was the link that led me to the right answer.

    It told me...

  • RE: Bad IT People

    Stories like these are the reson I laugh nervously and update my resume' anytime I am somewhere that executives or higher start to talk about the business limitations of SOX,...

  • RE: The Percent Sign in T-SQL

    Toreador (3/1/2011)


    or more accurately

    8 = 2 (mod 6)

    Tell me what the "=" is and we will use wet noodles for the beating. :w00t:

  • RE: The Percent Sign in T-SQL

    mtillman-921105 (3/1/2011)


    OK, The next time I submit a question, I'll be sure that the fluke answer, if there is one included, can in no way me misconstrued as a possible...

  • RE: Heaps

    Ninja's_RGR'us (3/1/2011)


    SKYBVI (3/1/2011)


    ChazMan (3/1/2011)


    I'm still confused about how the page is full. Since data pages are 8K and we are only using 4K, how is that full?

    Also, in my...

  • RE: Heaps

    Nice question Steve.

    I know the Page Split is a problem with some updates.

    Actualy glad to be wrong about it being a poblem on M$ SQL server...

  • RE: The Percent Sign in T-SQL

    mtassin (2/28/2011)


    But somebody else could have said "Hey if I modulus 0 by 0 I get a divide by zero error!" and selected the last option, not realizing you were...

Viewing 15 posts - 436 through 450 (of 673 total)