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

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