Browse By Tags

  • How can I find the SQL execution plan for a custom view in SQL Server Management Studio?

    How can I find the SQL execution plan for a custom view in SQL Server Management Studio?

    You may have created some custom views in your Sage X3 system but are finding them slow to execute. The first step in diagnosing poorly performing SQL is often checking the SQL execution plan, but how can you do this with Sage X3 custom views? First…

  • Looking to build a report for Sales by GLCode by month

    Hi, as the subject says, I am building a report to pull sales numbers per company by GLCode in sql server. I'm having a hard time getting data that looks correct. I have tried a few different ways of joining SORDER table to GACCOUNT table. I've tried…

*Community Hub is the new name for Sage City