I need some information regarding Windows Mobile5.0

i am using windows mobile 5.0 .Now iam downloading the total database from remote system using synchronization.but it is a huge database.so i want to download only some part of the databse.i.e in employee table somany employees will be there.from there i want to download only one employees data from that database.

Can we do this using synchronization concept.Here i want to use XML schema.That XML file will be downloaded into the PDA and will be converted to SQLCE.And while uploading the XML file will be uploaded and the data will be stored into the SQLSERVER of the remote system.

Can anyone give me guidance in this issue sothat iam very greatful to them.

If you are using merge replication and you are pulling the entire publication to the mobile device, you might want to simply put some filters in place. you can establish horizontal or vertical filters on your publication so that only certain rows or columns in the publication propagate to the SQL CE or SQL Mobile database.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replperf_5kx1.asp

If you want to use XML instead, you might review the 4 new Northwind sample apps such as

http://msdn.microsoft.com/library/en-us/dnppcgen/html/nw_pocket_analyze_decision_support_wm2k3_sp.asp?frame=true&_r=1

many of which use XML as a mechanism of data synchronization with SQL CE on device.

-Darren

i need help regarding sql data types and pointers.

hello, i have a few questions here which i hope anyone can help me.

1. how do i go about using the image data type?

2. how to use pointers to point to a specific file? for example, if i want to point to a music/image file, how do i go about doing that?

i'd appreciate if anyone can help me.

thx! :) .1. Read Books Online.
2. The best method is to store the file path in the database.|||Refer these also
http://www.aspfaq.com/show.asp?id=2149
http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part3/c1161.mspx

I need documentation re: dedicated SQL Server

I am searching for some reliable-source documentation regarding why SQL
Server should be run on a dedicated server. Can anyone provide me with
links to such documentation?mkerrigan@.ktoys.com wrote:
> I am searching for some reliable-source documentation regarding why
> SQL Server should be run on a dedicated server. Can anyone provide
> me with links to such documentation?
It's about resources: cpu, memory, disk. Do you need to maximize the
resources your database server has a particular piece of hardware or do
you (more like "can you") afford to have SQL Server share resources with
other applications?
It's better to run SQL Server in isolation, but if your database is
small enough or does not have a lot of activity, then your server
hardware may suffice running more than one service.
David Gugick - SQL Server MVP
Quest Software|||David Gugick wrote:
> mkerrigan@.ktoys.com wrote:
> > I am searching for some reliable-source documentation regarding why
> > SQL Server should be run on a dedicated server. Can anyone provide
> > me with links to such documentation?
> It's about resources: cpu, memory, disk. Do you need to maximize the
> resources your database server has a particular piece of hardware or do
> you (more like "can you") afford to have SQL Server share resources with
> other applications?
> It's better to run SQL Server in isolation, but if your database is
> small enough or does not have a lot of activity, then your server
> hardware may suffice running more than one service.
>
The server is running approximately 30 databases with various rates of
activity, some users coming in from out of state. The largest database
so far is about 2 GB and these will all grow. Currently the server is
also running Backup Exec's SQL Server engine as well as some other
applications and services. We are trying to justify dedicating a
server to just using SQL Server, and the higher-ups want to see
documentation, preferably from Microsoft. I have been unable to find
anything specific.|||mkerrigan@.ktoys.com wrote:
> David Gugick wrote:
>> mkerrigan@.ktoys.com wrote:
>> I am searching for some reliable-source documentation regarding why
>> SQL Server should be run on a dedicated server. Can anyone provide
>> me with links to such documentation?
>> It's about resources: cpu, memory, disk. Do you need to maximize the
>> resources your database server has a particular piece of hardware or
>> do you (more like "can you") afford to have SQL Server share
>> resources with other applications?
>> It's better to run SQL Server in isolation, but if your database is
>> small enough or does not have a lot of activity, then your server
>> hardware may suffice running more than one service.
>>
> The server is running approximately 30 databases with various rates of
> activity, some users coming in from out of state. The largest
> database so far is about 2 GB and these will all grow. Currently the
> server is also running Backup Exec's SQL Server engine as well as
> some other applications and services. We are trying to justify
> dedicating a server to just using SQL Server, and the higher-ups want
> to see documentation, preferably from Microsoft. I have been unable
> to find anything specific.
I don't really think this is a "documentation" decision. If you
eliminate all costs involved, it's easy to justify using a dedicated box
for SQL Server. Once you consider the added costs of another box, an
additional OS, added maintenance and support, these are certainly
concerns that must be considered. What's most important here is what
effect these other apps/services are having on your SQL Server
operational performance. You really need to make this decision based on
you particular environment and requirements. I would encourage you to
not make this decision based solely on someone's opinion - including
mine :-)
If you need help figuring out what effect these other services are
having on SQL Server, then start a new thread with that question and I'm
sure you'll get a lot of system profiling suggestions.
David Gugick - SQL Server MVP
Quest Software

I need documentation re: dedicated SQL Server

I am searching for some reliable-source documentation regarding why SQL
Server should be run on a dedicated server. Can anyone provide me with
links to such documentation?
mkerrigan@.ktoys.com wrote:
> I am searching for some reliable-source documentation regarding why
> SQL Server should be run on a dedicated server. Can anyone provide
> me with links to such documentation?
It's about resources: cpu, memory, disk. Do you need to maximize the
resources your database server has a particular piece of hardware or do
you (more like "can you") afford to have SQL Server share resources with
other applications?
It's better to run SQL Server in isolation, but if your database is
small enough or does not have a lot of activity, then your server
hardware may suffice running more than one service.
David Gugick - SQL Server MVP
Quest Software
|||David Gugick wrote:
> mkerrigan@.ktoys.com wrote:
> It's about resources: cpu, memory, disk. Do you need to maximize the
> resources your database server has a particular piece of hardware or do
> you (more like "can you") afford to have SQL Server share resources with
> other applications?
> It's better to run SQL Server in isolation, but if your database is
> small enough or does not have a lot of activity, then your server
> hardware may suffice running more than one service.
>
The server is running approximately 30 databases with various rates of
activity, some users coming in from out of state. The largest database
so far is about 2 GB and these will all grow. Currently the server is
also running Backup Exec's SQL Server engine as well as some other
applications and services. We are trying to justify dedicating a
server to just using SQL Server, and the higher-ups want to see
documentation, preferably from Microsoft. I have been unable to find
anything specific.
|||mkerrigan@.ktoys.com wrote:
> David Gugick wrote:
> The server is running approximately 30 databases with various rates of
> activity, some users coming in from out of state. The largest
> database so far is about 2 GB and these will all grow. Currently the
> server is also running Backup Exec's SQL Server engine as well as
> some other applications and services. We are trying to justify
> dedicating a server to just using SQL Server, and the higher-ups want
> to see documentation, preferably from Microsoft. I have been unable
> to find anything specific.
I don't really think this is a "documentation" decision. If you
eliminate all costs involved, it's easy to justify using a dedicated box
for SQL Server. Once you consider the added costs of another box, an
additional OS, added maintenance and support, these are certainly
concerns that must be considered. What's most important here is what
effect these other apps/services are having on your SQL Server
operational performance. You really need to make this decision based on
you particular environment and requirements. I would encourage you to
not make this decision based solely on someone's opinion - including
mine :-)
If you need help figuring out what effect these other services are
having on SQL Server, then start a new thread with that question and I'm
sure you'll get a lot of system profiling suggestions.
David Gugick - SQL Server MVP
Quest Software