No i dont want to do like this...there are millions of records and I can't copy from excel to db everytime

so that I have run SSIS package, it will insert...

Thanks ..........its working fine now........

Hi Gail,

Thanks for the reply....

Actually I don't know much about the Oracle.

Could you please tell me here deleted is the column name or table name, because in SQL SERVER we...

Hi Gail,

Thanks for the reply....

Actually I don't know much about the Oracle.

Could you please tell me here deleted is the column name or table name, because in SQL SERVER we...

Thank you Grant...this will help me a lot

Hi lynn,

when they are updating or selecting any data that time the performance will be slow.

Thanks

Thanks for the reply...

I run the query, but still I am not able to get, what is the issue. Please take a look the results when i executed the query.

SQLTRACE_INCREMENTAL_FLUSH_SLEEP 1193793959 1367

LATCH_EX 89361955 3223305

CXPACKET 41858655 1684455

BACKUPIO 10339306 341072

BACKUPBUFFER 9273282 203284

ASYNC_IO_COMPLETION 8343013 54

LCK_M_S 8037900 18372

LCK_M_U 6707010 1635

LCK_M_IU 3575857 1652

WRITELOG 3188065 414686

PAGEIOLATCH_SH 2587725 13881

ASYNC_NETWORK_IO 1465321 7457

SOS_SCHEDULER_YIELD 574212 536542

BACKUPTHREAD 302396 588

LCK_M_IX 293313 189

Thanks

@Kev:

Thanks for the reply..

As I earlier mention that datafile is growing not log file, and the mdf file size was 6 GB but now size of mdf file is 8.88...

Thank you very much for replying me...............

Thank yoiu very much for your prompt reply.....:-)