Forum Replies Created

Viewing 15 posts - 271 through 285 (of 3,666 total)

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

    erichansen1836 (9/22/2015)


    I guess you don't put much value in the manpower required to implement and maintain this solution.

    Does not require manpower or womanpower.

    All you have to do 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: Are the posted questions getting worse?

    Lynn Pettis (9/22/2015)


    Alvin Ramard (9/22/2015)


    Lynn Pettis (9/22/2015)


    Alvin Ramard (9/22/2015)


    Grant Fritchey (9/22/2015)


    jasona.work (9/22/2015)


    I think I need an intervention...

    I keep going back to the "Jet" topic, it's like watching a train wreck...



    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: MS-Jet Engine 4.x ODBC enabled databases to 1 Terabyte/5 billion rows (or) SQL SERVER?

    erichansen1836 (9/22/2015)


    ... The cost is FREE. ...

    I guess you don't put much value in the manpower required to implement and maintain this solution.



    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?

    Lynn Pettis (9/22/2015)


    Alvin Ramard (9/22/2015)


    Grant Fritchey (9/22/2015)


    jasona.work (9/22/2015)


    I think I need an intervention...

    I keep going back to the "Jet" topic, it's like watching a train wreck and I can't stop...

    Absolutely...



    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?

    Grant Fritchey (9/22/2015)


    jasona.work (9/22/2015)


    I think I need an intervention...

    I keep going back to the "Jet" topic, it's like watching a train wreck and I can't stop...

    Absolutely NO intention of posting...



    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: Database Size

    SoHelpMeCodd (9/22/2015)


    The following will fail for databases within which your account is not a db_datareader. ...

    That's normal. You cannot query a database if you do not have sufficient rights.

    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: MS-Jet Engine 4.x ODBC enabled databases to 1 Terabyte/5 billion rows (or) SQL SERVER?

    I still don't understand so may keep responding to this thread. It won't die if you keep reviving it.



    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?

    Jack Corbett (9/18/2015)


    Okay, I'm going to give the instructor the benefit of the doubt. Maybe lesson 1 is cursor and lesson 2 is set-based and there will...



    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: MS-Jet Engine 4.x ODBC enabled databases to 1 Terabyte/5 billion rows (or) SQL SERVER?

    erichansen1836 (9/18/2015)


    ... I am happy enough with my workaround ...

    Definition of workaround: Red flag telling you you should consider a different solution. 😎



    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?

    Student: Teacher, do you want the solution based on your methodology, or the correct solution? 😀



    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: Logging and Error Handling for SQL Stored Procedures

    Charles Sommers (1/20/2014)


    ...

    I wish the catch block could pass an ErrorObject to a sproc. I don't want each sproc to be responsible for logging messages. I want to...



    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: Best way to learn Data Warehousing Concepts?

    Luis Cazares (9/18/2015)


    The main or basic book you should read to learn the concepts of data warehousing is: The Data Warehouse Toolkit[/url]

    It's a great book.

    Good book. There's other books in...



    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: Date format got changed b/w two different version of SQL Server for the same web request

    This sounds like a Windows issue. SQL Server doesn't have a set format for datetimes, that I know of.

    Check the Windows settings on each server for date and time format.



    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 script to create folders

    Lowell (9/18/2015)


    rather than an arbitrary count of 1000 or some other static value, would it make more sense to put files in folders based on the dates?

    you could group by...



    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: Dynamic SQL Question

    If they use dynamic SQL for most of their SQL then I suspect they're either stuck in a rut or don't know the correct way to do things.

    Someone needs...



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