Tips to improve MsSQL db performance

If SQL database has poor performance, it will cause timeout issue during retrieve data.  Usually, we have below tips to improve its performance:

1. Re-build indexes (check the index fragmentation first)
2. Review the SQL execution plan to find out the most time consuming part (READ MORE)

What is Manufacturing execution system (MES)

Manufacturing execution systems (MES) are computerized systems used in manufacturing, to track and document the transformation of raw materials to finished goods. MES provides information that helps manufacturing decision makers understand how current conditions on the plant floor can be optimized to improve production output.[ MES works in real time to enable the control of multiple elements of the production process (e.g. inputs, personnel, machines and support services). (Read More)