So, 30 minutes for 2000 rows, yeah that performance sucks. I am assuming you are running this at your desk in BIDS?

Are both the file server that holds the...

Ok, I see it now.

For anyone looking for it, it is at:

http://www.sqlservercentral.com/Forums/Topic1192171-1292-1.aspx

CEWII

Ah, sorry, know I've seen that but not where.

And why do you care?

CEWII

Are you trying to do this programatically?

Otherwise just look at the service manager, open the SQL service, the path to the service is listed there.

CEWII

If you do a DBCC DBREINDEX it will defrag all the indexes on the table.. Why are you trying to go index by index?

CEWII

Having done this recently...

I like mount-points, they help with the problem of running out of drive letters for sure.

However, there are some things to keep in mind.

You can...

My advice is start a new thread don't hijack one. Once thats done we can see about an answer. This thread is 18months old, lets let it be.

CEWII

Foulcon:

First add that IP address to the machine itself, then you should be able to make this work.

EdVassie:

This might work in SQL 2005 but it won't work with 2008 clustering,...

So do you see anything like TCP 10.10.10.149:1433 already? Do you see ANY references to TCP port 1433?

CEWII

With the SQL server down do a netstat -an

look for any entries that reference port 1433 such as TCP 0.0.0.0:1433, I'm guessing there is something already listening on that...

faulcon (10/17/2011)

---

Well the virtual machine is running on a hyper-v cluster, but that's not the cluster you're talking about, correct? I'm fairly certain there is no sql server cluster...

There is "sort of" a way to do this, but it is gonna take some work. You can assign an IP address to each instance and force it to...

Take a look at the doc, most of it was based on your work and I gave you credit for your assistance. And if you see something missing or...

Are you the Lowell who wrote the docs for it from the discussion on there? I just added a tweaked up version as a docx file last week.

CEWII

I would store the filename as a last step in the load process and do the load process as transactionally as possible. Then at the top of the process...