Forum Replies Created

Viewing 15 posts - 31 through 45 (of 45 total)

  • RE: Question of the Day for 10 May 2007

    I agree with the above comments that none of the options meet all the requirements.

    If management put the priority on cost over storage size, option 1 appears to be the...

  • RE: switching to compatibility level 90

    Here is another one we ran into just yesterday.

    (DB compatability = 80) IsNumeric('\') = 0

    (DB compatability = 90) IsNumeric('\') = 1

    It seems that the backslash is a money character in...

  • RE: My Projects Have Never Failed

    I would agree with many of the comments.  I learned a long time ago that often, if you give the users exactly what they ask for,  it won't be what...

  • RE: killing a large bcp

    I recently ran into the same problem.  Once I figured it out, though, the answer was obvious.

     

    First, the BCP utility has a batch parameter that allows you...

  • RE: killing a large bcp

    I recently ran into the same problem.  Once I figured it out, though, the answer was obvious.

     

    First, the BCP utility has a batch parameter that allows you...

  • RE: Question of the Day for 23 Mar 2007

    Agreed.  I assumed the second "2382" was supposed to be "2383", but also failed.

  • RE: Gedcom files

    GEDCOM files are simply text files.  The information within the GEDCOM file uses a pre-defined format/structure (called GEDCOM - hence the name) that relates the data.  If you have a GEDCOM...

  • RE: Writing to a File Using the sp_OACreate Stored Procedure and OSQL: The

    Additional note: The 446,000 documents totaled 274MB in size.

  • RE: Writing to a File Using the sp_OACreate Stored Procedure and OSQL: The

    11/13/2006

     

    I have discovered the problem with my text file generation degradation.

     

    It all comes back to the file system.  As files are being generated and more...

  • RE: Writing to a File Using the sp_OACreate Stored Procedure and OSQL: The

    Zach, you have this correct.

     

    To flesh out the scenario a bit, this is a conversion process from one application to another involving as much as 10-15 years...

  • RE: Writing to a File Using the sp_OACreate Stored Procedure and OSQL: The

    Be very careful with how you interpret the article’s conclusions!

     

    Real world scenario:  I am currently having to take narrative information stored in a SQL Server 2000 db...

  • RE: How to convert column in rows

    Here is a generic function I wrote several years ago for the same purpose.  I'm sure there are newer/better ways, but this has always helped me in a pinch.  Feel...

  • RE: Working More?

    Definitely working more, and loving it!

    Five years ago I was working for a dying manufacturing company (auto-related, in the Detroit area).  40+ hours/week with flex time, but you never knew...

  • RE: Christmas Poll

    I went somewhat nuts one year (though I can't say I compare to Steve).  When I saw that my electric bill went up over $100 for that month, I decided...

  • RE: Data Quality

    I just left three years of work in the real estate industry.  Most of the last year involved working with a local MLS service, taking their paper documents, converting them...

Viewing 15 posts - 31 through 45 (of 45 total)