Forum Replies Created

Viewing 15 posts - 3,016 through 3,030 (of 5,685 total)

  • RE: general questions

    testers (6/10/2011)


    they are just general interview questions.

    So I figured. Since I won't let you use my knowledge and hard work to get yourself a job, I'll lend you a hand...

  • RE: convert ntext to varchar

    sqldba_icon (6/9/2011)


    thanks..let me provide some more details..there is a table more than 100 gb in size with a column ntext which occupies 90% of total table space. Goal is to...

  • RE: Is this even possible?! Mass update agent jobs via script.

    You can either browse sysjobsteps and perform an update against that, or script out all your jobs and do a find/replace on the email you want to remove, and rebuild...

  • RE: general questions

    testers (6/10/2011)


    What advantages is there to moving indexes to a separate drive? What raid would you use?

    How do you estimate the size of a table?

    What is the process that...

  • RE: Can anyone solve this question..PLZ

    Need a fourth filegroup for what's in front of AVM.

    There's always the 'unbounded' group in the front.

  • RE: DTS vs. SSIS Row-End Detection

    Oh, for anyone interested, the code below. MainStreamBuffer is an output buffer that is NOT synchronized to Input 0 in properties. Because of this, ProcessInput must be overridden,...

  • RE: DTS vs. SSIS Row-End Detection

    opc.three (6/10/2011)


    Craig Farrell (6/10/2011)


    I've ended up turning those last 3 columns into a single column as far as metadata is concerned and shoving the entire process through a synchronous script...

  • RE: SQL Safety Nets

    IceDread (6/10/2011)


    ORM is becoming more and more common in todays products and development of different solutions. With ORM we lose the power of security throu stored procedures.

    I would like to...

  • RE: DTS vs. SSIS Row-End Detection

    Crispin Proctor (6/10/2011)


    You sure the EOL is CRLF and not just CR or LF?

    Try either option on its own.

    Yeah, because it works fine for the full rows, so I know...

  • RE: DTS vs. SSIS Row-End Detection

    opc.three (6/10/2011)


    Phil Parkin (6/10/2011)


    I'm interested to know how you avoided getting a meta-data error as a result of the expected columns being missing on the dodgy row?

    Guessing a little but...

  • RE: Shown up by a developer

    mtillman-921105 (6/9/2011)


    Thanks for the interesting discussion everyone.

    Most of the tables I work with have no PK (I primarily work in data warehouses). It's kind of a shame that a...

  • RE: Shown up by a developer

    Scrap last comment, sorry. Please provide the second plan that's now occuring as well.

  • RE: Why Can't We Code?

    Revenant (6/8/2011)


    Craig Farrell (6/8/2011)


    The only thing a previous employer must disclose is your existance at having worked at a firm and your hiring/leaving dates. That's it. Anything...

  • RE: Why Can't We Code?

    Revenant (6/8/2011)


    Elliott

    I read your reply and wonder whenre does the former employer's right to cover their *** ends and where my right to get technically relevant information about a prospective...

  • RE: Are the posted questions getting worse?

    Kiara (6/8/2011)


    SQLRNNR (6/8/2011)


    Kit G (6/8/2011)


    Grant Fritchey (6/7/2011)


    WayneS (6/6/2011)


    Jim,

    If I've read things right, you're going to the Summit? Do you know that Thursdays up there is "Kilt Day"? Grant started it......

Viewing 15 posts - 3,016 through 3,030 (of 5,685 total)