Forum Replies Created

Viewing 15 posts - 421 through 435 (of 584 total)

  • RE: XML to Relational

    SQL Kiwi (1/26/2012)


    I dislike questions that make a parser/syntax checker out of the reader, especially where there is little in the way of learning value

    As soon as I saw the...

  • RE: Strings and Defaults

    Nice one Gail. Always good when a question has a twist that's straightforward. (I almost went for 1 and 1, until I remembered ...) Thanks!

  • RE: Concurrent Administration

    Got it right because I took it at face value. Thanks for the question.

  • RE: Hashing

    An unexpected adventure into hashing - Hash Tuesday anyone?

    Thanks for the stimulating question Steve.

  • RE: billy-yons and billy-yons of rows

    Hugo Kornelis (1/20/2012)[/bI was not able to find a price quote on that machine. But I am sure that, whatever the price is, multiplying it by 20,000 will suffice for...

  • RE: billy-yons and billy-yons of rows

    Hugo Kornelis (1/20/2012)


    Just for kicks ...

    ...you would need to have almost 200 million of those machines.

    You left out the most important part of the calculation, for the money anyway. What...

  • RE: DDL trigger

    Thanks for the effort and great question.

  • RE: Multiple Inserts

    Toreador (1/17/2012)


    Hugo Kornelis (1/17/2012)


    A good question, and it's hard to see how anbody could contest the correct answer.

    How long before someone complains that the correct answer is an error message...

  • RE: Checking database access

    Is it Monday? Thanks for an easy one.

  • RE: Backup Compression

    sknox (1/5/2012)My guess is that it was inherited from tape systems, as the compression option for tape was historically implemented in firmware because back in the day general purpose CPUs...

  • RE: Backup Compression

    arun1_m1 (1/5/2012)


    Thomas Abraham (1/5/2012)


    Thanks for the easy and straightforward question. Sometimes not having to think hard first thing in the morning is great.

    And then I started thinking ... but WHY...

  • RE: Backup Compression

    Thanks for the easy and straightforward question. Sometimes not having to think hard first thing in the morning is great.

    And then I started thinking ... but WHY can't they co-exist?...

  • RE: Query Tuning

    Nice Question! Thanks Jeff.

    I'd like to add a "me too" for the NON-SARGable example of the ISNULL.

  • RE: Triggers

    And our IT manager gets nervous when there are four triggers on a table - performance concerns! (So much of our ERP front-end has the business rules in the forms....

  • RE: ANSI_PADDING

    Hugo Kornelis (12/19/2011)


    Thanks for the question, Jason.

    I only got it right because "3, 3, 1" was not in the answer options - that was the answer I was looking for...

Viewing 15 posts - 421 through 435 (of 584 total)