Forum Replies Created

Viewing 15 posts - 151 through 165 (of 820 total)

  • RE: Stunned

    Shawn Richards (8/28/2013)


    To be honest I find this disgusting and have had first had accounts of this many times while working in a Tech Supply Company Support Department around the...

  • RE: Stunned

    I thought that there would be a lot of comment about this. Good.

    I have worked with technically competent folks of both genders. Some more competent than others. ...

  • RE: SQL Server 2012 SSIS – Sending files using FTP Task

    raju400 (7/25/2013)


    Hi Guys ,

    ...

    i need to send only latest file to ftp site everyday not all of them ??? im new bie could anyone help me to sort this issue???...

  • RE: Using a Recursive CTE to Generate a List

    Jeff Moden (7/15/2013)


    jennym (7/15/2013)


    Agree completely, but wasn't sure a better alternative (the excel method has been worse for users than the CTE method so far). What would you recommend,...

  • RE: Using a Recursive CTE to Generate a List

    There are many ways to solve a problem. Some are better suited to situations than others.

    I think that the point of the article was to teach about recursive CTEs.

  • RE: Using a Recursive CTE to Generate a List

    Great article. I did spot one tiny thing though. You said:

    If you expect to have a list with more than 100 values ...

    That is a bit misleading. ...

  • RE: Automatically Generate Stored Procedures

    James A Skipwith (1/1/2013)


    ... Glad you liked the article. ...

    It was a great inspiration. I used this for a while and then made some improvements also. First I...

  • RE: Backup All Databases

    I like the idea of putting something like this as a task in a plan. This is dynamic in that it gets new databases without me having to do...

  • RE: Script for no of Index in a table

    Great script. Thanks.

    I added:

    ORDER BY HeapIndex DESC, t.name

    In that way the ones that I need to work on are at the top of the list. It's not so...

  • RE: Dynamic Database Backup

    Great script. Thanks for posting this. Often backups don't get done because it's too hard. This will help a lot. Folks should put this in place...

  • RE: What a View

    Sean Lange (10/2/2012)


    Or even better, just drop the prefix entirely. Object prefixes are one of my biggest pet peeves.

    I would agree with you except for name collision. My bet...

  • RE: What a View

    Diogy (10/2/2012)


    I'm not sure of the purpose of building views out of main tables programmatically. 😎

    There are environments where direct access to tables by user application is prohibited but read...

  • RE: casting uniqueidentifier to number and back

    This is not a problem unique to SQL 2012 but is more generic design. Even so ...

    The "mapping" table is a great approach. You would have identities from...

  • RE: Adding Global and Scope Variables

    I can see many uses for it. I can also see the two at sign notation carring on the "tradition" of temp tables.

    Conversly would name spaces be better for...

  • RE: Trade-offs

    Sigerson (9/25/2012)


    "...

    As I read in another post in this forum, from Abraham Lincoln, "If I had 8 hours to cut down a tree, I'd spend 6 hours sharpening the ax."

    Get...

Viewing 15 posts - 151 through 165 (of 820 total)