Forum Replies Created

Viewing 15 posts - 1,306 through 1,320 (of 6,486 total)

  • RE: "Real" copy of Codd's 12 (13) Rules for RDBMS

    David Portas (8/1/2010)

    Jeff Moden (8/1/2010)

    Maybe I have your intention wrong but look again. Tom said that a NULL could not be used to explain WHY data was missing (or...

    August 1, 2010 at 4:25 pm

    #1200806

  • RE: Software Vendor Security

    marco-870908 (7/27/2010)

    umailedit (7/27/2010)

    "Firewalling and anti-virus are not really necessary anymore. Vista and up from installation on have NTFS settings that lock down the system."

    Whoah! Where did you get the...

    July 27, 2010 at 12:59 pm

    #1198913

  • RE: Are the posted questions getting worse?

    GilaMonster (7/26/2010)

    Lynn Pettis (7/26/2010)

    Going to work for Honeywell. Government contracts, about all I can really say.

    Sounds intriguing...

    DBCC TIMEWARP @CIACleanse @userID='Lynn Pettis' @noHamsterPoo

    July 26, 2010 at 12:31 pm

    #1198377

  • RE: Are the posted questions getting worse?

    Tom.Thomson (7/25/2010)

    Matt Miller (#4) (7/24/2010)

    ...why is just a fancy way to say - use a SET statement up front to set the parameter's value (using a function if need be),...

    July 25, 2010 at 12:26 pm

    #1197953

  • RE: "Real" copy of Codd's 12 (13) Rules for RDBMS

    Jeff - I believe you're looking for the October 1985 article series in Computerworld, by Codd, entitled:

    Does your DBMS Play by the rules

    From Codd's own description it's the first...

    July 25, 2010 at 12:23 pm

    #1197952

  • RE: Are the posted questions getting worse?

    Lynn Pettis (7/23/2010)

    Lynn Pettis (7/23/2010)

    Okay gurus, here is a question I was asked and I can't seem to find the answer.

    Why can't I pass simple functions (1 + 2) or...

    July 24, 2010 at 11:12 pm

    #1197912

  • RE: Is Data Integrity really important or not

    doobya (7/24/2010)

    I've always implemented constraints to keep me, my devs and data analysts from getting sloppy

    yes - especially when you are evolving the application (and doubly so when making online...

    July 24, 2010 at 9:04 pm

    #1197911

  • RE: Is Data Integrity really important or not

    doobya (7/24/2010)

    because the proc had to select the user account to check the balance already

    the foreign key constraint was unnecessary

    a single check constraint is quick but that isn't a common...

    July 24, 2010 at 5:19 pm

    #1197904

  • RE: SQL query join between table and FOR XML output

    mark-list (7/22/2010)

    Aaahhhh perfect, thanks so much!

    Happy to help!

    July 22, 2010 at 8:02 pm

    #1197303

  • RE: Math function question

    brian.cook (7/22/2010)

    Matt Miller (#4) (7/22/2010)

    Jeff Moden (7/22/2010)

    Joe Celko (7/22/2010)

    brian.cook (7/22/2010)

    Thanks, I knew it would be something simple!

    Actually, using the proprietary MONEY is a huge problem. It does not divide...

    July 22, 2010 at 1:29 pm

    #1197142

  • RE: Math function question

    Jeff Moden (7/22/2010)

    Joe Celko (7/22/2010)

    brian.cook (7/22/2010)

    Thanks, I knew it would be something simple!

    Actually, using the proprietary MONEY is a huge problem. It does not divide or multiply correctly. ...

    July 22, 2010 at 1:10 pm

    #1197123

  • RE: SQL query join between table and FOR XML output

    This is usually done using (yes, I am going to really say it) a correlated subquery instead.

    Try it doing something like:

    Select o.OrderId, o.OrderTitle,

    (Select OrderId, Name, Description

    From OrderDetail...

    July 21, 2010 at 5:49 pm

    #1196573

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (7/19/2010)

    Kit G (7/19/2010)

    CirquedeSQLeil (7/18/2010)

    What has happened to the nefarious one called Gus?

    Gus was working on a contract where web access was strictly monitored, so he didn't feel comfortable posting....

    July 19, 2010 at 10:53 am

    #1195014

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (7/10/2010)

    Alvin Ramard (7/10/2010)

    CirquedeSQLeil (7/10/2010)

    Matt Miller (#4) (7/10/2010)

    Jeff Moden (7/9/2010)

    The Dixie Flatline (7/9/2010)

    Jeff, you have hp on the brain.

    You need to clean the cages out more often...

    July 10, 2010 at 2:47 pm

    #1191166

  • RE: Are the posted questions getting worse?

    Jeff Moden (7/9/2010)

    The Dixie Flatline (7/9/2010)

    Jeff, you have hp on the brain.

    You need to clean the cages out more often ,,, or naybe less often. ...

    July 10, 2010 at 12:46 pm

    #1191149

Viewing 15 posts - 1,306 through 1,320 (of 6,486 total)