Forum Replies Created

Viewing 15 posts - 2,296 through 2,310 (of 7,484 total)

  • RE: Today's Random Word!

    BWFC (8/27/2014)


    Punched tape

    5-bit punched tape

    edit: I used both 5-bit an 8-bit in the distant past; can't remember whether Orion II used 6-bit or 8-bit, so may have used 6-bit too...

  • RE: Production Subsets

    crussell-931424 (8/25/2014)


    What's the compelling reason to use a subset of data? If it is no big deal to copy a recent backup into a test area, why not just do...

  • RE: max ids of two tables - compare

    Is this what you want?

    if ((select max(ID) from table1)=(select max(ID) from table2)) exec xp_cmdshell c#program ;

  • RE: Functions as predicates and SARGable queries

    Uwe Ricken (8/25/2014)


    24 Bytes for the record (uups i calculated in my previous answer wrong - thought 4 bytes for CCode 🙁 )

    4?? Surely 2 ? 4 would have...

  • RE: Are the posted questions getting worse?

    Evil Kraig F (8/25/2014)


    TomThomson (8/22/2014)


    Haven't noticed him recently on SQLServerCentral, though :cool:.

    Oh, he's been around a while. He stopped at one point. I'd hoped they'd shut his...

  • RE: Today's Random Word!

    Ed Wagner (8/25/2014)


    Sean Lange (8/25/2014)


    djj (8/25/2014)


    Ed Wagner (8/25/2014)


    SQLRNNR (8/25/2014)


    Ed Wagner (8/22/2014)


    TomThomson (8/22/2014)


    crookj (8/22/2014)


    djj (8/22/2014)


    Ed Wagner (8/22/2014)


    Reaper

    Vision (The Grim Reaper's Brother)

    Wonder Man

    Wonder Woman

    Diana

    Charles

    William

    Burroughs

    DEC (Digital Equipment Corporation)

    PDP (Programmable Data Processor)

  • RE: Need unique number for groups of records

    CELKO (8/19/2014)


    >> Say there's a table with these records: <<

    You missed every fundamental concept you need here. Rows are not records. Your narrative (we post DDL instead) is useless; it...

  • RE: Testing is Your Best Investment

    If you want code working and out of the door quickly, there's only one way to do it: first spend enough effort understanding requirements and usability issues, if possible discussing...

  • RE: PIVOT

    Steve Jones - SSC Editor (8/24/2014)


    Added "functions" to the QotD, though I think you're being a bit pedantic, Tom.

    So do I 🙂

  • RE: Question regarding the difference between two different ways to populate a new table in TSQL

    Jeff Moden (8/24/2014)


    I absolutely agree that they'd better be able to pull the proverbial rabbit out of the hat on schema design to enable high performance code to be written...

  • RE: Question regarding the difference between two different ways to populate a new table in TSQL

    Eirikur Eiriksson (8/24/2014)


    TomThomson (8/24/2014)


    Jeff Moden (8/23/2014)


    There's nothing wrong with challenging a DA when it comes to performance

    up to there I agree with you 100%

    because, and with absolutely no malice...

  • RE: PIVOT

    Eirikur Eiriksson (8/24/2014)


    Since you wrote such a long post Tom, I guess you really got it wrong:-P

    😎

    I get verbose when I'm in pedantic :alien: mode, and poor wording in QotD...

  • RE: Question regarding the difference between two different ways to populate a new table in TSQL

    Jeff Moden (8/23/2014)


    There's nothing wrong with challenging a DA when it comes to performance

    up to there I agree with you 100%

    because, and with absolutely no malice in my heart,...

  • RE: PIVOT

    One of those awkward questions that requires a guess as to what the question's author meant. And getting that guess right is far more difficult than the technical...

  • RE: Are the posted questions getting worse?

    GilaMonster (8/22/2014)


    TomThomson (8/22/2014)


    Haven't noticed him recently on SQLServerCentral, though :cool:.

    He dropped in recently to state that indexes were only needed in badly designed databases.... 🙁

    Interesting. If he actually said...

Viewing 15 posts - 2,296 through 2,310 (of 7,484 total)