Forum Replies Created

Viewing 15 posts - 151 through 165 (of 1,047 total)

  • RE: Job step indicates success when if fact failed, why?

    raotor (8/17/2012)

    I figured out what I'd done wrong, but am concerned as to why the job continued on despite a failure to INSERT new rows into a table.

    So, what was...

    August 17, 2012 at 7:51 am

    #1527085

  • RE: Learning C

    Steve Jones - SSC Editor (8/16/2012)

    I think C really is a good place to get early because it makes you be very careful.

    Agreed. Sloppy programmers don't have much success with...

    August 16, 2012 at 10:25 am

    #1526715

  • RE: Learning C

    TravisDBA (8/16/2012)

    One cannot blame the car for their poor driving skills.:-D

    Ever hear of the Yugo? :hehe:

    August 16, 2012 at 10:06 am

    #1526702

  • RE: Learning C

    Lynn Pettis (8/16/2012)

    I have to disagree with you. First, C & C++ programmers don't know things from the get go, they had to learn about the penalties for using...

    August 16, 2012 at 9:13 am

    #1526656

  • RE: Learning C

    roger.plowman (8/16/2012)

    Much of my objection to C comes from the sheer grunt work of memory management. C is notorious for memory leaks and buffer overflows. While VB dialects before VB.Net...

    August 16, 2012 at 8:36 am

    #1526625

  • RE: Learning C

    Eric M Russell (8/15/2012)

    If you teach them C, they'll spend weeks learning how print "Hello World" on a console, will never use it, and will forget everything three months.

    Ah,...

    August 16, 2012 at 8:10 am

    #1526606

  • RE: Learning C

    Alex Gay (8/16/2012)

    I wouldn't recommend C as a starting language, but once you can program it is always good to learn what your compiler is doing behind the scenes, or...

    August 16, 2012 at 7:25 am

    #1526566

  • RE: INSERT with ordered select

    rrn 62873 (8/15/2012)

    Thank you for the tips.

    Specifying the index as unique did shave off time in the overall processing from what I had tested previously.

    But creating the index after the...

    August 15, 2012 at 7:55 am

    #1526004

  • RE: While Loop into a Set Based Insert

    Man this is one ugly POS, probably written by a VB programmer.

    Yes, it can be re-written to be set based and it would run light years faster. To be honest...

    August 15, 2012 at 7:06 am

    #1525977

  • RE: INSERT with ordered select

    try inserting into the temp table without an index (or just use select into ) and without the order by, then create the clustered index after the insert.

    Also, create...

    August 15, 2012 at 6:37 am

    #1525964

  • RE: "UPDATE" Is Not Updating Correctly

    I hate it when UPDATE doesn't update correctly.

    August 14, 2012 at 1:26 pm

    #1525758

  • RE: unique constraint

    CELKO (8/11/2012)

    I apologized, I would appreciate it if you would just leave it at that.

    But I do not want you to quit sniping at me. I like adversarial...

    August 12, 2012 at 9:40 am

    #1524852

  • RE: unique constraint

    Eugene Elutin (8/10/2012)

    But the reality is that natural and surrogate keys each have their advantages and disadvantages, and there is no solution which is perfect for all situations. In...

    August 10, 2012 at 11:07 am

    #1524567

  • RE: unique constraint

    Lowell (8/9/2012)

    what is the difference between a unique constraint and a unique index? i thought they were the same thing;

    The underlying functionality is the same, but the DDL is different....

    August 9, 2012 at 11:33 am

    #1523997

  • RE: Displaying data

    looks like a homework assignment. You should read the textbook and do the labs. :-P:-P

    August 9, 2012 at 11:15 am

    #1523980

Viewing 15 posts - 151 through 165 (of 1,047 total)