What are Statistics in SQL Server and why do they matter to me?
What are Statistics in SQL Server and why do they matter to me? Executive summary – You want to ensure that at the data base level your configuration to maintain statistics are set properly. This means that AUTO_CREATE_STATISTICS is set to ON, ...
Continue readingThe SQL Command Override
Business Insights Explorer (BIE) tasks can quickly compile data using a SQL query from data existing in one or more Sage 500 tables. The user can personalize a BIE task by filtering, grouping, and subtotaling the data as needed.
Continue readingCreate a Custom Task in Sage 500 ERP
You created a custom Business Insights View (BIE) but now you need to grant access to users so they can start using it from their menu. In order to add the view to the menu, you must add it in the Task Editor (System Manager > Tools > Task ...
Continue readingIndex Advantage, Surprise this is Relative.
If you have spent any time performance troubleshooting your SQL Server, you have probably run across Glenn Berry’s SQL diagnostic queries. In one of these, using the missing index DMVs, Glenn calculates a column called Index_Advantage. I was ...
Continue readingSage 500 ERP Surrogate Keys and Checking for Inconsistency
How to check for inconsistencies in the Sage 500 ERP surrogate key values If you are familiar with the database schema of Sage 500 ERP you have likely come across the need to understand the use of surrogate keys in the database. Most tables within ...
Continue readingAutomate the Sage 500 ERP Daily Aging Recalculation
Sage 500 ERP Aging Recalculation Within Sage 500 ERP, there are tasks that allow you to age all of your Open Receivables and Open Payables to ensure that they are current when viewing this information on reports and explorer views throughout Sage ...
Continue readingMicrosoft SQL Server on Linux: An Initial Look
There have been a number of stunning developments recently in the Microsoft world. We’ve known since March that SQL Server was coming to Linux, so the November preview release wasn’t a complete surprise. .NET Core already is bringing Microsoft’s ...
Continue readingRunning Sage 500 7.2 on SQL Server 2014
As you may well know, Sage is not formally supporting Sage 500 7.2 any longer and when they did support it, it was not supported for anything beyond SQL Server 2005. We’ve had a number of requests asking if it is possible to run earlier versions of ...
Continue reading