So you don't know if the problem is solved. You'll know ONLY...

http://sqlblog.com/blogs/aaron_bertrand/archive/2009/07/30/when-will-my-backup-restore-index-reorganize-finish.aspx

IIRC look in dm_exec_requests there's an estimate end time column in there. That column is populated for backups, restores, checkdb. I've never heard of it being populated for...

I'm no SSIS guru but I know this for sure, you can commit the whole process in batches and unless you specifically ask for an ordered insert you won't get...

river1 (5/25/2011)

---

sorry did,t undestood your question.

What i did was:

I created some new indexs on some tables includind the liquidacao table.

This are new indexs created on tables.

I have tried create the...

cfradenburg (5/25/2011)

---

Another issue is that this could leave hypothetical indexes in the database. I'm...

Has it been 24-48 hours already since you created the index?

If you created the index on...

Do you plan on regressing to sql 2K???

Focus on what you need...

Then the import is not done sequentially.

What are you using to import the data? SSIS, sps, bulk?

SeanAchim (5/25/2011)

---

Thanks John - it looks like I'm going to need a lot of luck on this one.

We are not using any replication on this DB at all - so...

Yes if by same time you mean 3 minutes later :w00t: (joke in case it's not obvious)!

zach_john (5/25/2011)

---

The data commits after every 5K records each record populates 5 tables. I have other tables in using a similiar ID but along with a date as a PK...

opc.three (5/25/2011)

---

The idea of having an app generate a sequential GUID outside the database and provide it to SQL Server as the clustering key for a table is great on...

Put double quotes around the path in the command.

How's the linked server configured? Use current connection?

Can you create a specific login for that linked connection and give explicit permissions?

For a TEST you can use SA for the...