Hi,

What you want to achieve?

If you have a proper backup, you can restore the DB no issues in that.

You need to create the same structure in SQL server .

You can bcp out the datas from oracle and bcp in the same to SQL. No issues in bcp since...

Yes he is having RTM version installed.

Please install service packs

Hi ,

You can take log backup and shrink the files.

How you connecting to the database?

How much is the percentage of utilization now??

As Timoty said Profiler uses resources..You can go for Server side Trace to track the issue.

Go ahead all the best

Hi Phil ,

How you checked the service pack details i hope you used select @@version which gives only windows service pack.

Run select serverproperty('productlevel') which gives SQL Server Service pack Info.

What was your default collation?

To which collation you changed?

You can create different file groups and files inside that and can specify the tables to be created under particular filegroup

Thanks All 🙂

Gila you are genius in SQL server...Those articles are excellent

Hi Shankar,

What you mean by partition in SQL Server?

If u create a database you can specify the initial size ,growth and where the data and log file to reside.

you can...

Hi Experts,

I am sorry if am wrong..

Can anyone please tell me what are ghost records and thier impact?How can we handle the same?

TIA

Thanks Victor,

That is point in time recovery is not possible when we have bulk insert operation. Hope i am right 🙂

Thanks All