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_SLEEP11937939591367

LATCH_EX893619553223305

CXPACKET418586551684455

BACKUPIO10339306341072

BACKUPBUFFER9273282203284

ASYNC_IO_COMPLETION834301354

LCK_M_S803790018372

LCK_M_U67070101635

LCK_M_IU35758571652

WRITELOG3188065414686

PAGEIOLATCH_SH258772513881

ASYNC_NETWORK_IO14653217457

SOS_SCHEDULER_YIELD574212536542

BACKUPTHREAD302396588

LCK_M_IX293313189

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.....:-)