Avoid Potential SQL Server tempdb log file issue when switching from Table Variables to Temporary Tables in a Stored Procedure called by a Data Window retrieval

Tech Articles

Avoid Potential SQL Server tempdb log file issue when switching from Table Variables to Temporary Tables in a Stored Procedure called by a Data Window retrieval

Details

Written by David Lacey

Category: PowerBuilder

Published: 04 July 2018

Last Updated: 10 July 2018

In SQL Server it is generally a good idea to use temporary tables, rather than table variables within your stored procedures. Temporary tables perform much better, particularly with large volumes of data, as SQL Server is able to compile statistics on the data in temporary tables. However, if you are calling your stored procedures from a Powerbuilder application, you may find that the switch to temporary tables has an unwanted side effect. Here is how the unwanted side effect comes around and what to do about it.

https://www.selecttop.co.uk/440194269

https://www.youtube.com/watch?v=7QK-N6dQxNg

Prev Next

Comments (0)

There are no comments posted here yet

Find Articles by Tag

64-bit Application Event Handler Linux OS Script Repository ODBC COM PowerBuilder Compiler DataWindow Text Database Table Data Bug Class Testing UI Messagging Database Table Schema RibbonBar Builder Database Profile TLS/SSL Oracle OLE SVN Trial SOAP PowerServer Mobile Sort Database Painter Database Charts PFC Event REST SQL DragDrop Web Service Proxy NativePDF RESTClient Authorization DLL External Functions Interface Export Windows OS Debug GhostScript PowerServer Web Mobile Database Table Service Import JSON Platform TortoiseGit Array Design Stored Procedure Git PDF 32-bit PostgreSQL ODBC driver PowerBuilder SnapDevelop Validation JSONParser SDK Android Event Handling CrypterObject WebBrowser IDE SQL Server Database Object Migration API Automated Testing Expression Resize Installation Outlook HTTPClient RibbonBar Configuration PBDOM Debugging Windows 10 Icons PostgreSQL Jenkins License Debugger CI/CD JSON Source Code JSONGenerator SqlModelMapper XML .NET Assembly OrcaScript Encryption Authentication Branch & Merge Icon Web API Model Open Source .NET Std Framework DataWindow JSON RichTextEdit Control ActiveX PowerBuilder (Appeon) TreeView Data BLOB SqlExecutor PowerScript (PS) Graph Encoding Variable UI Themes Database Connection TFS Filter .NET DataStore Syntax InfoMaker Performance OAuth File Deployment PDFlib WinAPI Excel OAuth 2.0 UI Modernization MessageBox Export JSON Source Control iOS Menu SnapObjects Transaction DevOps Azure CoderObject Elevate Conference Window Import Error DataType C#