IBExpert Database Solutions: How to improve you Firebird/Interbase database?

How to find the procedures, trigger and views, that do not use an index in their operations?
How to find the procedures and triggers that have typical type casting problems?
How to know if your database servers garbage collection is working?
How to change the Character Set of all tables in a database?
How to compare the metadata of different databases and create a script that does all required changes?
How to activate a Version Control System for stored procedures and Triggers?
How to compare the current database object with an object in another database?
How to create a sql for a insert, update, delete or other statements automatically?
How to find all objects that have dependencies to the current object?
How to compare different hardware and database server concerning the speed?

See Solutions from the IBExpert Team below:

firebird – super user/developer

At work I[Norman Dunbar] use a tool named TOAD and have recently been voted as a
TOAD MVP (Most Valued Professional). In my bio I have a plug for
Firebird. :o)

1 180 181 182 183 184 201