Forum Replies Created

Viewing 15 posts - 7,171 through 7,185 (of 7,483 total)

  • RE: INSERTED DUPLICATE RECORDS

    Jeff Moden (11/23/2007)

    Yep... you're right... database sure can't do any of that And, I'm sure that the VB program does it with much more speed...

    Everyone does realize that...

    Tom

    April 4, 2010 at 11:03 am

    #1145479

  • RE: 3nf, functional dependancy and head exploding

    David Portas (8/16/2008)

    Ask yourself what are the determinants of publisher_city? If they are not super keys of this table then it is not in BCNF (probably not 3NF either but...

    Tom

    April 4, 2010 at 10:48 am

    #1145478

  • RE: Not well known about how E.F. Codd was rejected

    RBarryYoung (9/20/2009)

    Meh. Interesting historical references, but i'm not very impressed with the author's faux peer reviews. I read two of these papers when they were published (Codd's and...

    Tom

    April 4, 2010 at 10:07 am

    #1145475

  • RE: Expanding The Scope of Bridge Tables

    David Portas (3/23/2010)

    Ed-997158 (3/23/2010)

    Thanks. I was just going to ask if "bridge table" didn't already have a different terminology

    "Associative Entity" is semantic modelling terminology and not a relational database...

    Tom

    April 4, 2010 at 9:34 am

    #1145469

  • RE: Relational Model Advantages

    David Portas (11/26/2009)

    3. Developer productivity. SQL is a seriously deficient language for the 21st century when compared to other languages in the object-oriented world (C++, Java or C#). SQL’s 1980’s...

    Tom

    April 4, 2010 at 8:57 am

    #1145465

  • RE: The Missing Certification

    Chris-232075 (3/23/2010)

    I'm generally pro-certification, but specifically anti-Microsoft certification since so much of the information learned for passing their exams are product specific, and therefore, obsolete in relatively short order.

    It's...

    Tom

    April 4, 2010 at 6:04 am

    #1145448

  • RE: The Missing Certification

    GSquared (3/23/2010)

    I would very much favor an apprenticeship system. They have a very strong proven track record of working well (they have been the main training technique for most...

    Tom

    April 4, 2010 at 5:34 am

    #1145444

  • RE: Encryption

    Ric Sierra (4/1/2010)

    Matt Miller (#4) (4/1/2010)

    Ric Sierra (3/24/2010)

    vk-kirov (3/23/2010)

    Ric Sierra (3/22/2010)

    this undocumented function is available since SQLServer 7

    PWDENCRYPT is a hash function, which means it's a one-way function. Once hashed,...

    Tom

    April 4, 2010 at 4:26 am

    #1145435

  • RE: Double-Entry Bookkeeping for SQL Programmers

    Good editorial, and a very good point about techniques not officially supported against alternative (supported) methods.

    One minor niggle some extent it reads as if defensive programming is only about doing...

    Tom

    April 4, 2010 at 3:46 am

    #1145428

  • RE: Declarative Data Integrity

    Peter Trast (4/1/2010)

    You need to stop drinking those new Starbuck sized coffees http://www.starbucks.com/blog/10113/starbucks-listens-to-customer-request-for-more-sizes.aspx

    I mean, who really needs a 64oz. coffee??

    I made the mistake of following that url to see if...

    Tom

    April 1, 2010 at 12:54 pm

    #1144384

  • RE: Sparse Columns

    SQAPro (2/20/2009)

    note to self: don't take quizzes till fully caffenated.. could have sworn I was ticking a check box that said "CANNOT have a default value... grumble :angry:

    Me...

    Tom

    March 31, 2010 at 5:24 pm

    #1143552

  • RE: Declarative Data Integrity

    Paul White NZ (3/31/2010)

    C'mon Tom...let it go! Ron has already accepted that the statement is lacking twice on the thread already. It was a great QotD, with a...

    Tom

    March 31, 2010 at 3:02 pm

    #1143505

  • RE: Full backup Scenario

    Paul White NZ (3/31/2010)

    The whole backup operation is conceptually quite simple:

      Force a database checkpoint (flush all updated-in-memory pages to disk before anything is read by the backup)

      Record the minimum recovery...

      Tom

      March 31, 2010 at 2:58 pm

      #1143501

    • RE: Cast vs. Convert

      Paul White NZ (3/30/2010)

      Interesting - and nicely controversial. Thanks.

      I think I preferred your comment three weeks ago - I looked up controversial in my dictionary and it doesn't give...

      Tom

      March 31, 2010 at 5:02 am

      #1142957

    • RE: Counting spaces with datalength

      Paul White NZ (3/30/2010)

      Not my lucky day.

      That sounds as if you got it wrong. I can't resist asking which error did you make:

      a) 11 is an even number; or

      b)...

      Tom

      March 31, 2010 at 4:52 am

      #1142952

    Viewing 15 posts - 7,171 through 7,185 (of 7,483 total)