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

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