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

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

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