Category: SQL

SQL Server 2019 Troubleshooting

by | Mar 4, 2022 | , , | 0 |

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

by | Jul 12, 2021 | , | 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
Loading

Categories