Search results for query: *

I currently have Trasaction Durability enabled. The system is correctly producing the .LOG files. The problem I am having is the log files is that the old log files are remaining on the system log after the application and the trasaction that created them has successfully completed. Right now I...

does anyone know of a good whitepaper on setting up and recovering a database with transaction log files.

I am looking for a list of queries that query metadata information form a database ( Table size, Index names + base table, Size ( in Bytes) of rows stuff like that. There does not saeem to be allot written on the Pervasive database like Oracle or Sybase

I read the documentation on the create table command. I can not see a way to create a table as a subest ( both columns and data) form another table. In ORACLE SQL this is done by a CREATE TABLE as Select Statement). My question is is there an equivilent statement in Pervasive? Example: tbl1 (...

Does anyone know a good whitepaper on how to tune the Pervasive sql process ( Windows XP OS). I currently have a default sized server. given the amount of data that I am starting to process I know I have to expand the internal buffers. what I do not know is how or what to monitor to determin...

I need to write a query that will list table name and the number of columns in each table. example of results: table_name + # of COLs table_one | 20 table_two | 350 . . .