If you give me the format of the file you want to insert to the database (and maybe the table's DDL you want to insert in) I will tell you how...

BCP = Bulk Copy

This is an external exe file (coming with SQLServer. You can find it in the C:\Program Files\Microsoft SQL Server\80\Tools\Binn in a standard installation. More or less the...

I think also that dynamic SQL is the solution with a string contructed and executed with either a four part naming or an openquery syntax

Jim,

As far as I know the GPS devices are sending their data in a row format what you have to transalate first to XML and the import to SQLServer.

I wouldn't...

I think partinioned view would be the best solution for your problem as it distributes automatically the data across the table. One problem will still exist: you have to define...

To ba able to provide you with right advisis first I have to lnow the type of queries you want to execute against the database.

Primary key are of course important,...

No problem.

It will accomodate. It depends only on the hardware you are using.

We have for example some quite large SAP databases (over 400 GB each) where the biggest tables have...

Consider the following:

declare @rowcount int

set @rowcount = 100

set rowcount @rowcount

select * from MyTable

No, Ansar,

The small 3 means the remark #3 under the table:

David,

As there is no where clause in your main query you will have a full table scan.

What I would do is to create a clustered index on the INCIDENT_DETAILS table...

Or you can use the top clause with an order by. You just have to remember the last data shown.

This is and addition to Davif Pool's solution

So you query could...

Look I'm in Hungary and we use the Hungarian format (yyyy.mm.dd) and I was running some French companies as well.

SQLServer has really some predefied format where you don't have to...

What I would check is the indexes and the fragmentation via DBCC SHOWCONTIG at the first glance.

Also try to trace the file loading processes.

I don't know what you are doing...

Raid5 is suitable for low cost and mainly read only applications as every write operation needs to calcul the parity to be written to the parity disk.

Read operation can be...

as long as you are using some predefined date format from TSQL you couldn't cast it.

But if you are not sure about the format cast it or better convert it....