-2
votes
0answers
54 views

Purging millions of records from audit tables on a regular basis

I'm an accidental DBA. I want to purge millions of records from audit tables on a regular basis. I was told that Truncate is not an efficient way of doing it. Our firm doesn't have a DBA, so one of ...
0
votes
2answers
100 views

Reclaiming data file free space after deleting a large amount of data

I am an accidental DBA. We have a sql cluster that hosts 10 databases. Suddenly the size of one of the database increased drastically from 100GB to 250GB. When we checked the datafile, the size had ...
1
vote
1answer
65 views

cons of linked server providers not running in “allow in process” [closed]

what are the cons of having linked server providers not running in "allow in process"? SQL box crashed due to oracle provider crashing and it provider was running in "Allow in process", now have been ...
2
votes
1answer
742 views

Migrate / Copy Huge data from Oracle to SQL Server

I have huge tables in oracle database, appx 1 crore+ (10 million+) rows and want to migrate / copy those table and data in sql server. Currently I am using Import functionality of SQL Server for this ...