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

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