RKL eSolutions Blog Trends and Insights

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 reading
Tagged With: SQL Server

The 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 reading
Tagged With: Sage 500, SQL Server

Create 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 reading
Tagged With: Sage 500, SQL Server

Index 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 reading
Tagged With: SQL Server

Sage 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 reading
Tagged With: SQL Server

Automate 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 reading
Tagged With: Sage 500, SQL Server

Microsoft 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 reading
Tagged With: SQL Server

Running 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
Tagged With: SQL Server