Tag: Microsoft Dynamic GP

Top 5 SQL Tips for Microsoft Dynamic GP

Think necessity – Only look for the information you really need. The fewer rows that you pull in the quicker your query will be. Keep it simple stupid (KISS) – When you attempt to get fancy with the queries, it can have consequences. Meaning that the queries can take longer and pull unnecessary data. Overcomplicating…

January 28, 2017
Top 3 Reasons Your Database Maintenance Utility Won’t Run

1. The utility is run during a SQL server move to verify the database. This is always necessary when moving clients into a Multitenant move. I have run into an issue where the version of GP. 2. The database has an open query in SQL. If you ran a query in SQL and the Query…

January 26, 2017

Top 5 SQL Tips for Microsoft Dynamic GP