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

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