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

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