Thanks Luis for reply.

My only problem, that I do not want to develope an RDBMS for CE and actually there is already an SQLCE database. Even tough I could replace...

Basically what I want is to see and optimize the database within the emulator. Once it's fine I have to copy ot to the device.

My problem is that I don't...

A quick and dirty solution: fire them out of the SQL Server agent. There you can define the same execution start time so their will fire (more or less) at...

A question formulated like this is very difficult to answer.

You have to check a lot of parameters while you app is running slowly:

• deadlocks
• all other database activities

I've got more or less the same problem some months ago.

Check out the collation settings.

If the server default collation differs from the database collation or from the column collation you...

We have got Peregrine ServiceCenter.

From the principle it's the same. It is ganarating the indexes itself..

As it was quite poorle defined I've put some additional indexes on and have removed...

Some of the monitoring you can do by yourself too before buying any expensive tools.

First of all let's check the defragmentation's status (dbcc showcontig) of your database...

Just a small question:

How are you handling the different datatypes (eg. int, datetime money etc..) what you application would require?

Either you will use several columns of each required datatype (it...

Thanks for reply.

In this case how can I do the development using my emulator.

It must be feasible somehow because within embedded VB there is a condition "IsEmulator" which checks if...

You can do the same with MSSQL too

You can query the sysindex table to get the space usage informations, so you  can define the filter criteria you want.

Have a look...

In this case I would suggest to you to reindex and/or update the statistics.

You could also check how many rows you have for  01/01/04 and how many for 02/04/04

Of cours you have to test it.

In addition to that my suggestion is the following:

If you have a lot of small concurrent transactions then a quad proc is better, if...

Check if you have the same indexes.

Special attention should be made on the clustered index.

Reindex all of the indexes of your table with dbcc dbreindex.

This should reduce the size dramatically...

I usually bcp (or bulk insert) into a view when the file has fewer columns than my original table and I do not want to create a work table to...

A lot.

You can check the overall cache hit ratio, processor, disk and RAM usage, number of connections, deadlocks, number of full scans, file size grow (or even worse file shrink) during operational...