I have a table that contains some ten thousands of records,
and I've noticed that the join operations with others tables are very slow.
Can I use a clustered index in order to prepare that table before join and
select operations?

It seems to me that IsNumeric function is not supported by SQL Server CE.
Any other function that I can achive same functionality for this?
P.s : I do not want to use any language code(application level) to achieve
this ....I want to have this functionality in SQL level. As you ...

I get a parsing error on this:
UPDATE NewAlbumCbH SET Artist = 'asff', ArtistTime = 632763848830000000
WHERE ArtistTime = (SELECT MIN(ArtistTime) FROM NewAlbumCbH GROUP BY
ArtistTime)

I want to move data between SQL Server Mobile on a PDA and SQL Server on a
PC.  I would like to avoid RDA, Replication, and IIS.  Where can I find
examples of SQL INSERT statements that move data between a PDA and a PC?
I'm using C#, Visual Studio 2005 and SQL Server 2005.

I know the official position is that SQL Express does not support publishing
for merge replication or RDA. I have heard rumor that RDA might actually
work. Does anyone know how? Are there any third party tools to synch CE and
Express? Thanks,

SQLCE Gurus please check this out.
I'm getting an unexpected error in my APP.
File or assembly name 'System.Data.SqlServerCe,Version=3.0.3600.0,
Culture=neutral,PublicKeyToken=3BE235DF1C8D2AD3',or one of its dependencies,

I show a message on the PPC 2003 device showing "Please Wait - Syncing" so users won't pull the device out of the ethernet cradle while it is doing its periodic RDA Pull.  Only problem is when they do pull it during the RDA pull, it totally hangs up the machine.
I can trap for ...

How do I create a view with SQL Server Mobile Edition 2005?
When I created my database, it asked me if I wanted to support views in
it and I said yes.  When I create a query, it shows two tabs, one for
tables and one for views, so I'm assuming it supports views, but I

How do I use LIKE in a paramatized query. I tried this
WHERE     (HorseName LIKE @HName)
but it only works if you type in the entire text string Joeseph it can find
name Joeseph but if you type Joe it won't locate the record. Can someone

Hello
I have the next situation. A table that cotains a field that is a datatime
type
BirthDate and i want to extract from it only the date part as a date value

Am i right in saying that it's not possible to open a connection to a SQL
Mobile db on a device from a desktop VB2005 app using ADO.NET? (Or if it is
possible that this is only on a development machine?)
If that's the case then are my options to have the device use a web service

Tring to connect from PDA to MSSQL DB .
Error Code: 80004005
Message:
Minor Err.: 28016

System.Data.SqlServerCe.SqlCeException:SqlCeException: SqlCeException
S:Microsoft SQL Server 2000 Windows CE Edition HR:-2147024882 N:28558
SQL CE Errors:
Error 1 of 1

    Recently, we've decided to upgrade our Pocket Access database to SQL
Server CE. Reason being, our app need to support PPC 2002, 2003, and 2005
platforms because of the backwards compatibility requirements, and PPC 2005
platform does not support Pocket Access databases...