Any possibility of doing the same with only two tables but it should be normalized

Any chance of making this index maintanance plan automatically...

Hi,

Registrationno and date filed are not unique fields. Shall i create a index for datfield first then registrationno?

Huge insertion and deletion is going in my field. Is defragmentation be a...

Hi,

Thanks for your immediate reply..

Could you pls provide what are the dbcc commands i should look for..

While doing rebuild the index there wont be any data loss on the time?

Do...

Hi,

I have a updation on a datefiled for everyminute in all the records hence if i create a index on datefield wont it give a problem in writing..

Thanks & Regards

maheshkumar...

I have a frequent insertion and updation is going on so defragmentation is a problem in my current system?

Thanks & Regards

Maheshkumar

Hi,

First of all thanks for your reply..

We have around 1000 vehicles and for every minute all the vehicles status will be inserted with datetime, igntiion ,speed etc.. So in this...

Hi,

Thanks for your reply...

Actually the registrationno is going to be unique and it wil contain char value too hence i cannot use integer. I am having around 30k records and...

Yes i will do that. Could you suggest what could be the best method to move bulk records automatically from one server to another server

Hi

thanks for ur reply. Its has taken more than 3 minutes for the first transaction.

Dear all

Am also getting the same error and i even increased the timeout for the transaction. Still am stuck on this. Can any one provide me a solution on this.

I am just inserting all the records into the single table named as gpsdata_history. It will have a record of all the registrationnno irrespective of what ever clients they are....

We are in a vehicle tracking project and it is running for 24*7. We will get data for every min hence perday we have nearly1440 record for a vehicle and...

I forgot to mention in the previous reply and it is somewhere around 15,00,000 records in the total table.

It will give around 80,000 to 90,000 records. Inserting will also happen once in two days and that records are 100 times larger than the above. Will it be...