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

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