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

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