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

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