Slow Queries to Stored Procedures on MS SQL Server

Version 1

    Issue: When using Stored Procedures with MS SQL Server, it may take a long time to create temp tables and you may see many individual inserts into the temp tables.

     

    Resolution: If you're using Tableau Desktop or Tableau Server 9.0.5 or later, using the following TDC file might help speed things up:

     

    1. Open a new document in a plain text editor
    2. Enter the following:

      <?xml version='1.0' encoding='utf-8' ?>

      <connection-customization class='sqlserver' enabled='true' version='8.3'>

        <vendor name='sqlserver' />

        <driver name='sqlserver' />

        <customizations>

          <customization name='CAP_INSERT_TEMP_EXEC_STORED_PROCEDURE' value='yes' />

        </customizations>

      </connection-customization>

       

    3. Save the file with a .tdc extension and place it in the appropriate location:

    Tableau Desktop: Documents\My Tableau Repository\Datasources

    Tableau Server: Program Files\Tableau\Tableau Server\<version>\bin

    Note: Tableau Support does not test or troubleshoot .tdc files, and maintaining these files requires careful manual editing. Use with caution.