January 4, 2011 at 7:22 am
i have a situation to load 2 TB of data , it takes 1 week app of time , how to minimise the time it has only clusterd index.
January 4, 2011 at 7:25 am
Can you give some more information?
Or you copying or moving data?
Where does the data come from? A relational database, flat files, mainframe...
Do you append the data to something? Do you overwrite something?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 4, 2011 at 7:38 am
we are releasing the data to make some space on the server even it took lot of time for a select query .
January 4, 2011 at 7:42 am
I still don't know what you are trying to do.
Are you moving or copying data? Or are you deleting it?
From SQL Server to another SQL Server?
Is all the data in one table? In one database? Or on the whole server?
If you cannot tell us in clear words what you are trying to do, what you have tried before and what the desired results are, we cannot help you.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply