Forum Replies Created

Viewing 15 posts - 226 through 240 (of 355 total)

  • RE: Does It Count?

    My internet company promises 99.9% uptime. Imagine if they had scheduled outages and that was weekly and I couldn't use my internet during that time. It would be...

  • RE: RAID

    john.arnott (1/27/2011)


    I guess the point is to take advantage of the reduced risk in diversity of storage, whether it's geographic (off-site) or hardware based, and not to depend entirely on...

  • RE: RAID

    James Lean (1/26/2011)


    James Lean (1/26/2011)


    In RAID 0+1 you have two stripe sets that are mirrored, therefore you could theoretically lose all of the disks from one of the stripe sets...

  • RE: RAID

    Bob Cullen-434885 (1/26/2011)


    cengland0 (1/26/2011)Imagine if you lost one drive in the first spanned set of drives and one drive in the second spanned set of drives. All your data...

  • RE: RAID

    Bob Cullen-434885 (1/26/2011)


    I answered "the same", and was surprised to get it wrong.

    But, having thought more, doesn't the answer depend on how many drives there are? I was assuming four...

  • RE: What Not To Say

    tommyh (1/26/2011)


    Lynn Pettis (1/25/2011)


    The sad part about this, "It works on my machine", is that I have seen. I have also the where the code changes work perfectly in...

  • RE: RAID

    Good question today. I almost selected the option saying they have the same tolerance but then had to really think about it. I've lost data using spanned drives...

  • RE: sys.objects

    SanDroid (1/25/2011)


    Nice question. Obviously several people might learn something since "System base table" answer was almost as popular as the correct answer. 😎

    Yup, that's the one I selected and...

  • RE: sys.objects

    An easy question and I cannot believe I missed it. I answered too quickly without thinking about the other possibilities.

  • RE: Count Distinct

    Carlo Romagnano (1/21/2011)


    I get it right because of excluding the wrong choices.

    Exactly how I did it too.

  • RE: Transaction Log Files

    I couldn't possibly get this wrong after the recent lengthy discussions about VLFs.

  • RE: Tempdb

    Good question, thanks.

  • RE: Before Insert or Update Trigger

    Koen (da-zero) (1/10/2011)


    What kind of trigger? The question asks if it is possible with a trigger. So it is up to you to find out if there is a trigger...

  • RE: Before Insert or Update Trigger

    Got this one wrong because I didn't understand the wording of the question.

    Is it possible, using a trigger, to update a data row before commiting the insert to...

  • RE: VLFs in Log Files

    Hugo Kornelis (1/7/2011)


    But I would not consider such a setup robust, and I would urge management to invest in extra storage space.

    We tried that and our request was denied. ...

Viewing 15 posts - 226 through 240 (of 355 total)