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

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