Forum Replies Created

Viewing 15 posts - 811 through 825 (of 3,666 total)

  • RE: Cannot Open Datafile when running Agent Job

    xddevv (5/1/2015)


    hey guys so I think I figured it out.

    My last question, when I ask for permissions to the specific folder, do persmissions also have to apply to the...



    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: Where SQL Server stores SSIS packages?

    http://www.lmgtfy.com/?q=where+does+sql+server+2008+store+ssis+packages



    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: does anyone here still use database triggers?

    Grant Fritchey (3/26/2015)


    Piling on.

    ...

    Now, multi-statement, table-valued, user-defined functions on the other hand, those things are all things evil.

    You mean in a trigger? 😀



    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: does anyone here still use database triggers?

    Triggers are just like a number of other things some people call bad. They are not bad, but can be a problem if not used correctly.

    What do your triggers...



    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: Update binary column

    Have you considered looking at the code that did the insert?



    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: SSIS- Excel Source

    You will have to deal with each one individually.



    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: Drop Unused indexes?

    TheSQLGuru (3/23/2015)


    ...

    3) you MUST scan ALL source code for each index name you drop to ensure you don't break existing code that has index hints!

    I have to remember this one...



    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: Vendor Changed the Flat File Format

    Elliott Whitlow (3/23/2015)


    Why are you even accepting the file? Notify the vendor that the file format is set and that alterations are not tolerated. Its clear, if they...



    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: Vendor Changed the Flat File Format

    Welcome to the real world!



    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: query required

    g.britton (3/20/2015)


    I didn't need the database schema I need the table schema that is the CREATE TABLE statement. also please post some sample data and the desired up with using...



    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: How to subtract a column from a query result and add the difference to another

    I don't think anyone will be able to answer this without knowing more about the source data and the query hat returns the results shown.



    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?

    Maybe it's time to reboot the server in which life is running.



    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?

    Koen Verbeeck (3/20/2015)


    Alvin Ramard (3/20/2015)


    SQLRNNR (3/20/2015)


    Brandie Tarvin (3/20/2015)


    BWFC (3/20/2015)


    Brandie Tarvin (3/20/2015)


    I'm trying to figure out if this one is real or not. Anyone seen this? (click the link on the...



    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?

    SQLRNNR (3/20/2015)


    Brandie Tarvin (3/20/2015)


    BWFC (3/20/2015)


    Brandie Tarvin (3/20/2015)


    I'm trying to figure out if this one is real or not. Anyone seen this? (click the link on the tweet).

    https://twitter.com/petercopters/status/578548234756485120

    It's real alright.

    Wow....



    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: Rebuild index

    Barcelona10 (3/19/2015)


    Shrinking will fragment indexes

    I'm not saying shrinking is a good idea, but if you rebuild your indexes after shrinking, they will not be fragmented.



    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 - 811 through 825 (of 3,666 total)