Forum Replies Created

Viewing 15 posts - 7,411 through 7,425 (of 7,483 total)

  • RE: Storing IPv4 Addresses for Performance

    Elliott W (10/28/2009)

    I am not sure about this statement "I think this nicely illustrates that a little knowledge is a dangerous thing - it shows us what might happen when...

    Tom

    October 29, 2009 at 7:07 am

    #1072409

  • RE: LIKEable Brackets

    Hugo Kornelis (8/26/2009)

    Oh well, missed a point on a question designed to test something I knew, but learned an interesting thing - humans are still too smart for computers!

    Thanks. ...

    Tom

    October 29, 2009 at 5:19 am

    #1072348

  • RE: Theoretical Performance Issue Handling

    R. C. van Dijk (8/24/2009)

    The approach that the customer is always right, is totally wrong. Make them think they are right whilst feeding them with your own ideas is the...

    Tom

    October 29, 2009 at 4:50 am

    #1072337

  • RE: Encryptionphobia

    I haven't looked at SQL Server encryption, so maybe I'm getting things horribly wrong (maybe you can't do it right with SQL Server), but I can't understand why there should...

    Tom

    October 28, 2009 at 2:47 pm

    #1072085

  • RE: char to datetime!

    Christopher Stobbs (8/24/2009)

    I agree with the last two posts. I got it wrong cause I can't mind read.

    I can think of many examples where the cast is not implicit...

    Well, I...

    Tom

    October 28, 2009 at 2:09 pm

    #1072053

  • RE: Test Drive

    bob_silenzi (8/21/2009)

    Do your homework before you hire and its a safe bet you will get a good employee.

    Sounds like some sort of strange magic to me. I can't imagine how...

    Tom

    October 28, 2009 at 1:41 pm

    #1072039

  • RE: Storing IPv4 Addresses for Performance

    nimdil (8/19/2009)

    nicholastjh (8/19/2009)

    Nice article. Very informative.

    But at the final function where 128 is subtracted from the result of ParseName, before being multiplied by 16777216 (2^24), could potentially yield negative results,...

    Tom

    October 28, 2009 at 11:28 am

    #1071930

  • RE: RAID

    I knew what the answer would be, so I got it "right". But "right" has to be in quotes, because it is actually wrong for application screnarios where disk...

    Tom

    October 28, 2009 at 7:51 am

    #1071737

  • RE: SQL Server 2005

    It's hard to understand why MS introduced this storage format - perhaps they hadn't yet decided to provide table compression in the next version when they did this (although one...

    Tom

    October 28, 2009 at 6:53 am

    #1071674

  • RE: Unknown NULLs

    Kevin Gill (8/14/2009)

    The main impact of this that I've come across is that if you have two variables and both are null, the only complete equality check with ANSI NULLS...

    Tom

    October 27, 2009 at 9:01 am

    #1071261

  • RE: Truncating the log

    The BOL reference after the explanation doesn't help at all, as it doesn't refer the dump command. Anyway, even in SQL 2000 the dump command was deprecated, MS recommended...

    Tom

    October 26, 2009 at 6:08 am

    #1070633

  • RE: Stored procedures

    Well, I know what is supposed to happen so I got my point. But anyone still using SQLServer 2000 should be warned about this - the behaviour is erratic,...

    Tom

    October 26, 2009 at 5:58 am

    #1070630

  • RE: Building an API

    Jeff Moden (8/4/2009)

    I can't get over how many people are talking about sp's like they're new or something. 🙂 I've been a long time advocate of using stored...

    Tom

    October 26, 2009 at 5:40 am

    #1070619

  • RE: Be a Craftsman

    Interesting starting point (thanks, Steve) and some interesting comments.

    I agree with most of what Tom DeMarco says, but two things I don't agree with: that his discovery that the obsession...

    Tom

    October 25, 2009 at 10:04 pm

    #1070523

  • RE: Uptime = Downtime? (Database Weekly, Aug 3, 2009)

    mike brockington (8/5/2009)

    Heh... that's why I'm able to make a living.

    And how many times to you get brought in to sort out a system that had been 'upgraded' or...

    Tom

    October 25, 2009 at 7:40 pm

    #1070480

Viewing 15 posts - 7,411 through 7,425 (of 7,483 total)