Forum Replies Created

Viewing 15 posts - 1,681 through 1,695 (of 5,685 total)

  • RE: Unique constraint question

    opc.three (4/2/2012)

    To summarize, in Oracle, in single-column unique indexes NULLs are completely ignored. In multi-column unique indexes NULLs are considered if one or more of the columns participating in the...

    April 2, 2012 at 4:24 pm

    #1467945

  • RE: SSIS

    Export them from the SSIS server to a dtsx file. It's that easy to get the files available to you.

    To upgrade, simply open them in VS/BIDS 2k8 and save....

    April 2, 2012 at 1:58 pm

    #1467888

  • RE: Identity column Problem

    sqlserver8650 (4/2/2012)

    Hi All,

    Thanks for giving the replay

    Is there any chance to get order with out order by clause

    SQL Server will never guarantee an order without an order by...

    April 2, 2012 at 1:54 pm

    #1467884

  • RE: Are the posted questions getting worse?

    GSquared (4/2/2012)

    GilaMonster (4/2/2012)

    Evil Kraig F (3/30/2012)

    GilaMonster (3/30/2012)

    I read the end of that and I am not getting involved...

    Initial gut feel - improper transaction management (leaves transactions open) combined with connection...

    April 2, 2012 at 1:44 pm

    #1467873

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/2/2012)

    GilaMonster (4/2/2012)

    Evil Kraig F (3/30/2012)

    GilaMonster (3/30/2012)

    I read the end of that and I am not getting involved...

    Initial gut feel - improper transaction management (leaves transactions open) combined with...

    April 2, 2012 at 1:26 pm

    #1467856

  • RE: Are the posted questions getting worse?

    capn.hector (4/2/2012)

    SQLRNNR (4/2/2012)

    jcrawf02 (4/2/2012)

    Brandie Tarvin (3/29/2012)

    Greg Edwards-268690 (3/29/2012)

    Brandie Tarvin (3/29/2012)

    Just spent time in a meeting being reminded that people using the same terms do not always mean the same thing....

    April 2, 2012 at 12:53 pm

    #1467823

  • RE: records disappearing after insert, occasionally of course

    eshulman (4/2/2012)

    What is your suggestion to fixing the SELECT @@IDENTITY that we are using?

    Scope_Identity() is definately the preferred choice here, as mentioned.

    what we had - '<WebMethod(TransactionOption:=TransactionOption.RequiresNew)> _

    what we have...

    April 2, 2012 at 12:49 pm

    #1467821

  • RE: Are the posted questions getting worse?

    GilaMonster (3/30/2012)

    I read the end of that and I am not getting involved...

    Initial gut feel - improper transaction management (leaves transactions open) combined with connection pooling. Connection gets discarded from...

    March 30, 2012 at 5:00 pm

    #1467247

  • RE: Are the posted questions getting worse?

    Need some help here. Have occassional insert failures from a VB .NET app that checks later and finds the records missing. Errors are not properly reporting to the...

    March 30, 2012 at 3:47 pm

    #1467229

  • RE: records disappearing after insert, occasionally of course

    eshulman (3/30/2012)

    Thank you for your time.

    Not a problem. I'm going to try to call in some VB coding backup here, this went beyond my skillset I fear.

    March 30, 2012 at 3:44 pm

    #1467228

  • RE: Generating Test Data: Part 1 - Generating Random Integers and Floats

    Playing catchup on being underwater in a project for the last few weeks. Article looks great Jeff, and I'm sure will be very valuable. Nice Work!

    March 30, 2012 at 3:43 pm

    #1467226

  • RE: records disappearing after insert, occasionally of course

    eshulman (3/30/2012)

    Ok, we captured both the failed and the immediately following successful insert statements and rediously compared each field and each value and the two are absolutely identical.

    Except for a...

    March 30, 2012 at 2:45 pm

    #1467199

  • RE: Technical Interview - I feel dumb now.... :)

    Just to chime in with what's been good advice and discussion so far.

    Over 100k IS top of field right now in a number of markets. It's basically max of...

    March 30, 2012 at 1:25 pm

    #1467162

  • RE: records disappearing after insert, occasionally of course

    eshulman (3/28/2012)

    Thank you Craig - the thing that is really bizarre is that there are instances where our software tells the user that save failed and to save again -...

    March 28, 2012 at 5:35 pm

    #1466106

  • RE: records disappearing after insert, occasionally of course

    eshulman (3/28/2012)

    Craig, thank you very much. You gave us a ton of stuff to chew on. The script of the table is below. One thing we...

    March 28, 2012 at 4:42 pm

    #1466083

Viewing 15 posts - 1,681 through 1,695 (of 5,685 total)