Forum Replies Created

Viewing 15 posts - 211 through 225 (of 355 total)

  • RE: Length

    Carlo Romagnano (4/8/2011)


    Only one comment: I want back my points! :-D:-D:-D

    Ditto. Every other comment I was about to say has already been said.

  • RE: Logged Operations

    Good question. Got me two days in a row with lost points.

  • RE: Dating for DBAs

    Good question, I lost 2 points but learned something.

  • RE: Do You Need A Safe Word?

    OCTom (3/24/2011)


    All security systems are flawed. There is no perfect system. It depends on your level of risk acceptance versus the cost to the user if not able to log...

  • RE: SQL Server Job Steps

    Hugo Kornelis (3/24/2011)


    A good question. It would have been a great question if the author had not forgotten to specify the version - Powershell is not supported in SQL Server...

  • RE: Do You Need A Safe Word?

    Simple solution. Do not do anything by email. Have them log into the corporate web site (they must know their credentials to do that) and have them fill...

  • RE: Scaled-down SQL

    SanDroid (3/22/2011)


    I was talking about when the pounds are converted to Kilos before calculating displacement, since Kilos is the way to go, the math is always done wrong.

    What you...

  • RE: Scaled-down SQL

    SanDroid (3/22/2011)


    Great question. You would not believe how long and how often programers get this wrong.

    There is even a list that is maintained of ROM chips...

  • RE: T-SQL

    Hugo Kornelis (3/22/2011)


    A nice question. Thanks!

    My only gripe (yes, I have one - nopt a big one, though) is that the difference between 1 and '1' is easily lost. I...

  • RE: T-SQL

    Gopinath Srirangan (3/22/2011)


    And are you sure this below code executed successfully in 2005 ?

    insert into #test values

    ('1','A'),

    ('','B')

    Thanks

    It will not work in 2005. That's the server I use daily and...

  • RE: Scaled-down SQL

    Hugo Kornelis (3/21/2011)


    Good question; superb explanation!

    I guess that if the author had included "all of the above" as a fifth answer option, the rate of incorrect answers would have been...

  • RE: Scaled-down SQL

    Excellent question but this one got me. At first, I thought they would all return the same results and I was wrong so I definitely learned something new today.

    Kudos...

  • RE: RAID 10

    UMG Developer (3/4/2011)


    Thanks for the question.

    I would say that 4 is the correct minimum, otherwise you just have RAID1. (You are just mirroring two drives.) You don't get the +0...

  • RE: RAID 10

    I was about to answer 4 from my own knowledge but then looked it up to be sure and found this:

    http://en.wikipedia.org/wiki/Nested_RAID_levels

    It quotes:

    RAID 10 can be implemented with as...

  • RE: Issues with IsDate()

    Using that Stuff example, wouldn't that be the same things as:

    select isdate('1753'+ ' ')

Viewing 15 posts - 211 through 225 (of 355 total)