Forum Replies Created

Viewing 15 posts - 466 through 480 (of 646 total)

  • RE: A few reflections on RBAR by a weary application developer

    Hurt.Bill (12/8/2013)


    I agree. Don't let the bad data get to the database.

    Hey there. I agree as well, but, "bad" data is not just a matter of parsing the source...

  • RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

    Hi Jeff and Thierry. Thanks for the feedback. I appreciate that you both are being consistent in your approach. I know that many others are not.

    And I completely understand...

  • RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

    Jeff Moden (11/23/2013)


    Solomon Rutzky (11/23/2013)


    How can we tell there's no backdoor in the assembly?

    I feel that this is an odd and unfounded fear that many people seem to have. ...

  • RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

    There has been a bit of discussion following this post so I will start here, rather than assume people have been keeping up with the thread.

    thierry.vandurme (11/22/2013)


    CLR is all nice...

  • RE: sp_OAMethod to retrieve the file attributes from a folder

    jsteinbeck-618119 (11/7/2013)


    Hi,

    how much is it???

    Hello. In the interest of not stating anything here that gets outdated, that information, and more, can be found at:

    http://www.sqlsharp.com/full/%5B/url%5D

    Take care,

    Solomon...

  • RE: sp_OAMethod to retrieve the file attributes from a folder

    jsteinbeck-618119 (11/5/2013)


    Your code would need to co-exist in my trigger l posted earlier...

    I could use your to create and inline table function and pass in the location and file name......

  • RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

    Alan.B (11/5/2013)


    With your question about reasonableness, it's up to you. If performance wasn't an issue, why maintain two different functions? If it does matter, you can create a calculated column...

  • RE: Disk Is Cheap! ORLY?

    twin.devil (10/30/2013)


    excellent article i must say ... detailed enough for ppl who design database with closed eyes 😎

    good work !!

    Adam Seniuk (10/30/2013)


    Excellent article, disk is cheap until you start factoring...

  • RE: Disk Is Cheap! ORLY?

    aalcala (10/29/2013)


    Context is everything!

    I completely agree.

    I work on a number of web-based applications and for our applications we rarely see tables with more than 100K rows. On the other...

  • RE: Disk Is Cheap! ORLY?

    Joshua M Perry (10/28/2013)


    Disk is about to become more expensive. We are on the edge of a transition to flash storage which will make traditional disk go the way...

  • RE: Disk Is Cheap! ORLY?

    msmithson (10/25/2013)


    Great article.

    npodlesny (10/25/2013)


    I came across “Disk Is Cheap! ORLY?” post just now. Excellent, very comprehensive article!

    - Nataliya

    inuscz (10/28/2013)


    Thanks for a great article. I am still very young in the...

  • RE: Disk Is Cheap! ORLY?

    christopher reeve (10/25/2013)


    Great article and information (glad it was reposted on SQLServerCentral today)!

    Thank you :-).

    In regard to item #10 - while not denormalizing tables definitely applies to transaction systems (OLTP)...

  • RE: Disk Is Cheap! ORLY?

    Eric M Russell (10/25/2013)


    Excellent article.

    Thanks :-).

    In a corporate enterprise envrionment, it's not as if the sysadmin can just drop what they're doing, run down to the local electronics store, pull...

  • RE: Disk Is Cheap! ORLY?

    dhubbard (10/25/2013)


    Excellent article.

    Thank you 🙂

    I think the network bandwidth issue is really important and often overlooked. It is mentioned in the article, but I'd add that a WAN circuit...

  • RE: Explanation of LIKE '%[0-9]%'?

    Jeff Moden (7/29/2013)


    Eugene Elutin (7/29/2013)


    Jeff Moden (7/29/2013)


    Eugene Elutin (7/29/2013)


    Solomon Rutzky (7/27/2013)

  • 23847234872893475983479583749583749573945739 is all digits, is a valid number, but is NOT convertible to any SQL Server number types as it...

Viewing 15 posts - 466 through 480 (of 646 total)