Forum Replies Created

Viewing 15 posts - 3,976 through 3,990 (of 7,484 total)

  • RE: Partitioned index

    Nice straightforward question.

    Surprised it's 3 points, though; it's rather easy. The description of the data in the table (there are rows with same values for these...

  • RE: character ordering

    mtassin (11/1/2012)


    What's interesting for me is that the query from the original question returns 120 rows.

    select CHAR(I),I from Tally

    where char(I) between '0' and 'Z'...

  • RE: Halloween Protection

    Jeff Moden (11/1/2012)


    Gosh. I would hope that people know that it's not a Democracy. It's a Republic (well, it's supposed to be... I think "plutocracy" is probably more...

  • RE: character ordering

    SQL Kiwi (11/1/2012)


    The specific answer isn't useful, but the process of writing a query to answer it surely could be. I had no idea of the correct answer so...

  • RE: Halloween Protection

    Meow Now (10/31/2012)


    I stumbled across Freedman's explanation in my search on the subject and was thrown by the options as well. Either way, I selected the UPDATE choice as the...

  • RE: Halloween Protection

    This probably a pointless argumnent, because it isn't about anything technical, just about historical and terminological accuracy, and it does appear that quite a few people have adopted historically inaccurate...

  • RE: Halloween Protection

    craig 81366 (10/31/2012)


    GilaMonster (10/31/2012)


    Andrew Diniz (10/31/2012)


    After all, it is possible to observe 'Halloween Protection' in DELETE and INSERT plans too :hehe:

    No, the Halloween problem is exclusively for updates. You can't...

  • RE: Halloween Protection

    Nice question.

    I wonder how many people here ever used System R. I didn't, for one.

    Now, was it Halloween 1976 or Halloween 1977 when it acquired its name...

  • RE: LEAD - 1

    Nice to see a question about a new feature in sql 2012.

    Would have been a good question except for the ambiguities introduced by hving the result column that should have...

  • RE: Are the posted questions getting worse?

    I (installed and) ran SUPERAntiSpyware. It told me "I've found three things infected; I won't tell you what with, and I won't tell you which things. Maybe you...

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (10/29/2012)


    SQLRNNR (10/29/2012)


    Revenant (10/29/2012)


    Koen Verbeeck (10/29/2012)


    Brandie Tarvin (10/29/2012)


    This is the first I've heard of ransomware. Thanks for the heads up on it.

    They can be pretty nasty.

    Most of them disable...

  • RE: Are the posted questions getting worse?

    Jo Pattyn (10/29/2012)


    You run those programs in "windows safe mode"?

    Mostly not. But some of them, yes.

  • RE: Are the posted questions getting worse?

    WayneS (10/29/2012)


    Geez Tom, that's quite a bit of stuff you went through - hope I never have to do something like this. Sure am glad that you got it all...

  • RE: Parsing values in the WHERE clause

    Good question, but as has already been pointed out the explanation is wrong. The process of determining syntactic structure and deciding whether it's valid or not is parsing, not...

  • RE: Today's Random Word!

    ChrisM@home (10/28/2012)


    MJ brownies

    MJ tea

Viewing 15 posts - 3,976 through 3,990 (of 7,484 total)