DBREINDEX and INDEXDEFRAG example

Commands No Comments

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

Read the rest of this entry »

Some usefull SQL Commands

Commands No Comments

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 the rest of this entry »

Icons by N.Design Studio. Designed By Ben Swift and Customized by Ingrid Byllemos. Powered by WordPress
Entries RSS Comments RSS Log in