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


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
Comments (0)
There are no comments posted here yet

Find Articles by Tag

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