Forum Replies Created

Viewing 15 posts - 6,286 through 6,300 (of 7,484 total)

  • RE: Are the posted questions getting worse?

    GilaMonster (1/25/2011)

    North. About 9000km.

    Not sure, just thinking, maybe, will see, depends....

    Starting from Johannesburg I make that about Milan, or maybe a good bit East of there (around Bucharest) depending on...

    January 26, 2011 at 4:15 pm

    #1278852

  • RE: Corruption Detection

    paul.knibbs (1/25/2011)

    Tom.Thomson (1/24/2011)

    Another potential issue is physical deterioration of the media. This does happen as discs get older. In the old days drive hardware (or in even older...

    January 26, 2011 at 3:45 pm

    #1278834

  • RE: mixing numeric and text data in a single column

    Chrissy321 (1/26/2011)

    Hello All,

    My partner thinks its ok to send me a data file where they mix numeric and text data in a single column. When I protest they seem to...

    January 26, 2011 at 3:00 pm

    #1278816

  • RE: Table design

    Vedran Kesegic (1/26/2011)

    Like Andrew said, it's a classic many-to-many relation. In logical data model you have two entities: A and B. One A can have (contains, is associated with, etc)...

    January 26, 2011 at 2:27 pm

    #1278797

  • RE: sys.objects

    Nice easy question.

    But why have more than half the people who answered got it wrong? It is a straightforwards and easy one, isn't it? There's not something weird...

    January 26, 2011 at 2:17 pm

    #1278788

  • RE: RAID

    Steve Jones - SSC Editor (1/26/2011)

    Note that disks still fail. It's why when data is really critical, you can't necessarily wait on a rebuild. A disk failure from the same...

    January 26, 2011 at 2:03 pm

    #1278783

  • RE: RAID

    UMG Developer (1/26/2011)

    cengland0 (1/26/2011)

    No, that's not correct. In Raid 1+0, you have three copies of the data. In Raid 0+1, you only have two copies of the data.

    Really?...

    January 26, 2011 at 10:28 am

    #1278615

  • RE: Count Distinct

    Nice straighforward question. I like them like this.

    January 24, 2011 at 11:17 am

    #1277384

  • RE: Corruption Detection

    GilaMonster (1/24/2011)

    Steve Jones - SSC Editor (1/24/2011)

    You calculate a checksum across the page. When you read the page, you recalculate the checksum. If it doesn't match the value stored in...

    January 24, 2011 at 11:03 am

    #1277371

  • RE: Corruption Detection

    paul s-306273 (1/24/2011)

    I'd certainly go for Page Checksums, but do MS actually recommend that? Is it inferred that they are better because they also include torn page detection?

    Yes. The...

    January 24, 2011 at 10:43 am

    #1277355

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (1/22/2011)

    Definitely not SQL related, but my kid got his black belt today. Very proud of him.

    http://www.youtube.com/watch?v=DtIOe4IsUq8

    Congratulations to you and to the kid. A black belt...

    January 22, 2011 at 8:34 pm

    #1276945

  • RE: Critique - Common SQL Server Mistakes

    Steve Jones - SSC Editor (1/21/2011)

    Good point. I'll change the wording to say what the mistake is. Do you think

    - writing single row triggers

    or

    - not coding triggers for...

    January 21, 2011 at 1:25 pm

    #1276767

  • RE: Critique - Common SQL Server Mistakes

    Steve Jones - SSC Editor (1/20/2011)

    The NULL mistake is that people often write

    where a.col = null

    instead of

    where a.col is null

    The multi-row trigger is the same. Developers assume triggers fire...

    January 21, 2011 at 11:31 am

    #1276717

  • RE: Are the posted questions getting worse?

    Jeff Moden (1/20/2011)

    You left out "must provide a letter of recommendation from two living Presidents":-P.

    Actually I think it's "six (*) letters of reccomendation from the current Ministers President, one from...

    January 20, 2011 at 7:48 pm

    #1276342

  • RE: Critique - Common SQL Server Mistakes

    Question: why do you think multi-row triggers are a mistake? My view is that if you need triggers then single row triggers are usually a mistake, but multi-row...

    January 20, 2011 at 6:58 pm

    #1276334

Viewing 15 posts - 6,286 through 6,300 (of 7,484 total)