Forum Replies Created

Viewing 15 posts - 1 through 15 (of 3,665 total)

  • RE: Can Data Save the World?

    It will be harder for data to save the world when people in power keep saying it's fake news!



    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: Shared stored procedure with very complicated input

    Passing logic into a stored procedure sounds like a bad idea to 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: Creating a Robust SSIS Development Environment using the SSIS Catalog

    reinis - Monday, July 31, 2017 8:50 AM

    Phil Parkin - Monday, July 31, 2017 6:39 AM



    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: DNA for Data Storage

    We probably have enough unused DNA in our brains to store petabytes of data, or more. Who's working on the interface?  😉



    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: Tell Me a Joke

    Maybe I'm asking this in the wrong thread, but can anyone tell me where I can find documentation on DBCC TimeWarp?  ;-D



    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 load and in what order warehouse tables

    J Livingston SQL - Thursday, March 30, 2017 7:31 AM

    itmasterw 60042 - Thursday, March 30, 2017 6:42...



    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: Long running SSIS packages gradually use up memory

    I ran into a similar problem before importing thousands of files from an archive. I ended up setting up the package to only run for a few hours at a...



    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: Disk space full

    If you can't create more space on D then you can consider adding one or more disk(s) and either moving some of the files or creating additional database files on...



    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: Script to replace ","

    adonetok (12/6/2016)


    How to create a loop to go through all fields, all cells to replace "," with " " (space)?

    For example, there are 70 fields in a table ORDER.

    For some...



    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: Strange issue with basic SSIS Package

    Phil Parkin (11/18/2016)


    I suspect that the ? is not a ? in the data ... it's some other non-printable character.

    This code snippet shows that ?+ is no problem:

    IF OBJECT_ID('tempdb..#test', 'U')...



    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: Amending a DTS package (Integration Service) to include a WHERE statement on a date field.

    Eirikur Eiriksson (11/11/2016)


    andy.plumb (11/10/2016)


    thanks for the reply, I tried that and got error:

    Description: An error occurred executing the provided SQL command: "SELECT * FROM U_Observation WHERE UPDATED_DATE > DATEADD(YEAR-2,GETDATE())". Native...



    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: table structure

    peter478 (11/4/2016)


    Alvin Ramard (11/4/2016)


    Sounds like you're on the right track.

    okay but what is better? to have 3 tables separated or create one table... but, than I must create 3 relationship...



    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: table structure

    Sounds like you're on the right track.



    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: Upgrading from 2008 r2 to SQL 2016

    One thing you'll have to do is convert those DTS packages to SSIS.

    There are tools that can help you convert these, but I recommend you don't use them. Take...



    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 force column explicitly to string type before we export to excel

    Phil Parkin (10/5/2016)


    Eric M Russell (10/5/2016)


    Phil Parkin (10/5/2016)


    If there is one feature I'd love to see added is the ability to stronly type worksheet columns, meaning for example that all...



    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 through 15 (of 3,665 total)