Tagged: SQL

What is ADO and can it be used in Navision?

ADO (ActiveX Data Objects) is a Microsoft technology and is a interface to access data in a database.

So what can ADO be used for in Navision?

Read more »

DBREINDEX and INDEXDEFRAG example

If you have to optimize a lot of tables and indexes. You could create a SQL script, which then could be scheduled.

Read more »

Some usefull SQL Commands

If you are a SQL Server administrator or just working with it, these commands would be use full for you.

ALTER INDEX

Modifies an existing table or view index (relational or XML) by disabling, rebuilding, or reorganizing the index; or by setting options on the index.

Read more »