Forum Replies Created

Viewing 15 posts - 316 through 330 (of 3,666 total)

  • RE: MS-Jet Engine 4.x ODBC enabled databases to 1 Terabyte/5 billion rows (or) SQL SERVER?

    erichansen1836 (9/9/2015)


    ... Since Jet Engine 4.x is the more powerful of the two ...

    Huh? I hope you're thinking about a different Jet than I'm thinking about.



    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 File System Task Error: The process cannot access the file because it is being used by another process

    mrani.soukaina (9/9/2015)


    Thank you for ur answer Alvin, i tried the delay option before and it didn't work, still getting the same error...

    i thought maybe it's something related to the package...



    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 File System Task Error: The process cannot access the file because it is being used by another process

    Chances are the issue is due to your package processing files faster than Windows can release the file after processing. I've had that problem many times.

    You could try adding...



    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: Delete large number of records

    ScottPletcher (9/8/2015)


    There are two main reasons it's taking so long:

    1) no clustered index

    2) too many nonclustered indexes

    ......

    Ooops! Missed the lack of clustered index.



    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: Delete large number of records

    oneteabag (9/8/2015)


    1) No Trigger on the table, no cascade delete.

    2) The delete takes about 7 to 8 Minutes.

    Thanks

    For how many records?



    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 (9/8/2015)


    Grant Fritchey (9/8/2015)


    Alvin Ramard (9/8/2015)


    Steve Jones - SSC Editor (9/8/2015)


    Jeff Moden (9/3/2015)


    Alvin Ramard (9/3/2015)


    Grant Fritchey (9/3/2015)


    Another funny one today. Provided a DMV and a link to the documentation....



    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: Delete large number of records

    oneteabag (9/8/2015)


    Hi all,

    I have the following scenario and looking for some advise:

    SQL database on SQL 2012

    Large Production table 15 Million record

    The table has 3 years of data

    New monthly data is...



    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: The encrypted data in the project manifest failed to load

    You didn't answer my question!

    You probably have a usable package loaded, but how should I know if you won't answer?

    Take a look at what got loaded.



    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: The encrypted data in the project manifest failed to load

    Does the package(s) appear in the solution explorer?



    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?

    Steve Jones - SSC Editor (9/8/2015)


    Jeff Moden (9/3/2015)


    Alvin Ramard (9/3/2015)


    Grant Fritchey (9/3/2015)


    Another funny one today. Provided a DMV and a link to the documentation. I was asked "Is that real?"

    Nope....



    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: The encrypted data in the project manifest failed to load

    Barkstuff (9/8/2015)


    Thanks but I need to get to the source.

    Source of the error?



    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: The encrypted data in the project manifest failed to load

    I've had the same issue when loading packages created by others and they ran fine when I ran them.

    Chances are, the only thing that you might have to fix is...



    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: ISNULL vs IS NULL performance

    Maybe somebody said this already and I missed it, but don't forget that "field IS NULL" and "ISNULL(field,0) =0" are not the same thing.

    "field IS NULL" will not return records...



    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: matainence jobs are failing

    Looking at ... "(Object reference not set to an instance of an object.)" ...

    I would reconfigure every item in the package, especially the section where you select the database(s)....



    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: Remove String from column Post Code Field

    John Mitchell-245523 (9/8/2015)


    If it's an option for you, concentrate on cleaning the data. You're always going to find edge cases that you hadn't accounted for - maybe the two...



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