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

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