The SQL Server 2005 XML Temptress

  • Grant Fritchey

    SSC Guru

    Points: 395586

    We probably could use BCP and realize some performance improvements, definately. However, we're finding the performance is more than adequate, we've got it in Production as well as having tested it to a fair thee well, and the amount of code on both sides of the equation, the app server & the database, is a lot less than implementing a bcp solution would be. It really is working. Don't get me wrong. I don't see it as a magic bullet. It merely fills our needs well and could fill others needs under similar circumstances. As usual with databases, it depends.

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

Viewing post 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply