Forum Replies Created

Viewing 15 posts - 136 through 150 (of 3,666 total)

  • RE: Are the posted questions getting worse?

    Happy New Year everyone!!!

    I hope that 2015 was a good year for everyone and that 2016 will be an even better year.



    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 does datatypes get set when using select into in sql server?

    dndaughtery (12/30/2015)


    I used a select...into to create a staging table. Its been fine but lastnight I got a truncation error. I was under the "Assumption" that sql server looked at...



    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 remove minutes and seconds from DateTime?

    Got a bit messier than I was hoping for:

    SELECT DATEADD(Hour, DATEPART(hour, GETDATE()), CAST(CAST(GETDATE() AS DATE) AS DATETIME))



    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: Other Tools to Develop SSIS Package

    Eric M Russell (12/29/2015)


    At a bare minimum, all you need is Notepad, but the free SSDT tool provided by Microsoft provides some nice to have features too.

    Eric, if you're gonna...



    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?

    Phil Parkin (12/29/2015)


    Eirikur Eiriksson (12/29/2015)


    Phil Parkin (12/29/2015)


    Eirikur Eiriksson (12/29/2015)


    Phil Parkin (12/29/2015)


    Grant Fritchey (12/29/2015)


    Eirikur Eiriksson (12/29/2015)


    I really appreciate the effort of those who write the articles posted on this site but...



    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: Other Tools to Develop SSIS Package

    pietlinden (12/29/2015)


    Do you have SQL Server Data Tools? It's not a full version of Visual Studio. That's enough to do SSIS.

    That's not "enough" for SSIS. That is EXACTLY what...



    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 Do Staging Tables Belong

    Orlando Colamatteo (12/29/2015)


    I have had people scoff at running staging databases in FULL, taking backups and including them in Availability Groups and have had people scoff at running them 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: Are the posted questions getting worse?

    djj (12/29/2015)


    Michael L John (12/29/2015)


    The Detroit area is actually not nearly as bad as people may think, and, Michigan in general is a pretty nice place.

    Plus, you can...



    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 read Folder Names in SSIS

    Phil Parkin (12/28/2015)


    Have you also considered using a script task? It might be the most elegant solution in this case.

    Agree.

    Use a script task and save the script where you...



    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: Byte Me: Private Cloud

    Eric M Russell (12/23/2015)


    Alvin Ramard (12/23/2015)


    Eric M Russell (12/23/2015)


    Putting your data in the cloud: that's then you save a backup to external disk, and then have it boosted up 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: Byte Me: Private Cloud

    Eric M Russell (12/23/2015)


    Putting your data in the cloud: that's then you save a backup to external disk, and then have it boosted up the Space Station for safe keeping;...



    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: Byte Me: Private Cloud

    Ed Wagner (12/23/2015)


    mjh 45389 (12/23/2015)


    Eric M Russell (12/23/2015)


    Eric M Russell (12/23/2015)


    mjh 45389 (12/23/2015)


    I was in a shop at the weekend and they were selling external hard drives as 'Private Clouds'!...



    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?

    WayneS (12/23/2015)


    Brandie Tarvin (12/23/2015)


    Here's my QOTD:

    If it is Christmas, but you don't celebrate, does the tannenbaum still sing carols to the yule log during the Hanukkah code camp?

    now that depends...



    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: Select the rows that has only numeric data in varchar field

    gsc_dba (12/23/2015)


    Very slick solution Sean, kudos!

    Slick, but definitely not what the OP was asking for. The OP clearly said he wanted to select the values where ZIP was numeric...



    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?

    Phil Parkin (12/22/2015)


    Sean Lange (12/22/2015)


    Phil Parkin (12/22/2015)


    It seems that everyone in this thread spends their spare time shooting things :exclamationmark::-D

    I prefer making sawdust as my form of therapy.

    Plugging in my...



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