Category: SQL

SQL Server 2019 Troubleshooting

I had an indecent with a piece of software that was taking a very long time to perform a query to return about 300 items. Doing it one way through the program worked quickly however doing it another way took 3-4 times as long....

Read More

SQL Find and Replace for Intuitive 9.0

With Intuitive ERP 9.0 there is no way in the interface to update your server attachment links to a new server location. I ran the following script on a demo database and it changed all the links: UPDATE MediaItem Set MEI_Path =...

Read More