Forum Replies Created

Viewing 15 posts - 1,486 through 1,500 (of 3,666 total)

  • RE: handling a truncation error

    Are those US ZIP codes your storing in the SQL table? If so, why are you using NCHAR?

    Ignore this question if they're not US ZIP codes.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Common questions asked in SQL Server DBA Interview

    GilaMonster (10/8/2010)


    Please note, resurrected year-old thread.

    Ooops, timewarp malfunction?



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Common questions asked in SQL Server DBA Interview

    Brandie Tarvin (9/9/2009)


    Gail,

    You're hired! Come on over to Florida and we'll discuss your exhorbitant salary that is totally off the scale compared to the DBAs we currently have now who...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: One Million Posts

    Roy Ernest (10/8/2010)


    Let me also congratulate this site for hitting this milestone. 🙂 So Alvin, what did you get for hitting the milestone? Are you going to get the Alvin...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (10/8/2010)


    Ray K (10/8/2010)


    Gianluca Sartori (10/8/2010)


    At last, Mr. Celko gives a polite and useful answer to a poor-worded question.

    It's nice to see everyone can learn.

    I don't know. I...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    Jeff Moden (10/8/2010)


    The Dixie Flatline (10/7/2010)


    I just had an idea for an epic summer movie. It involves an intrepid group of DBA's and SQL Developers who...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: I have never tried this before.

    Jeff Moden (10/7/2010)


    I may be in a minority here. To me, SSIS is a four letter word. 😉

    There's nothing wrong with SSIS, but there are wrong ways to use...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: One Million Posts

    The Dixie Flatline (10/7/2010)


    Thanks to everyone for sharing your knowledge, insight, humor, and support.

    When you say humor, are you including me? 😀



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Running Different Data Flow Tasks Based on Time of Day

    imani_technology (10/7/2010)


    I've created the Script Task and a variable, but I have no idea how to get the Script Task to assign the time of day to the variable.

    Why can't...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Insert ID from CSV File

    Here's what I would do to get the SupplierId into the dataflow.

    Use the ForEach loop to assign the full file name and path to a variable. My first task inside...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Running Different Data Flow Tasks Based on Time of Day

    imani_technology (10/7/2010)


    Thanks! Do I need a script task for this or some other kind of task?

    You have a few choices. You need to a task before the dataflows so...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    Roy Ernest (10/7/2010)


    Anybody looking for chairs or recliners?

    How do we report spam?

    How to report spam? Yell as loud as you can: "STEVE!!!!!" 😀

    Click the Report button in the upper...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Running Different Data Flow Tasks Based on Time of Day

    imani_technology (10/7/2010)


    In SSIS 2008, I want to run a package once per hour (24 times a day). If the time that the package is running is before 5:00 p.m.,...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    GilaMonster (10/7/2010)


    Say what?

    http://www.sqlservercentral.com/Forums/Topic1000851-20-1.aspx

    Who's having luck with reading the tea leaves lately? Mind applying those divination skills to a QL2300 error?

    I thought the next version of SQL was going to be...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Any Idea How to Parse a file Like This

    Phil Parkin (10/7/2010)


    Seems like we've both spent enough time doing this stuff to know what works, Mr One Million 😀

    😀

    You understand that I didn't post a million all by myself,...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 15 posts - 1,486 through 1,500 (of 3,666 total)