That is not true. You can name the mirrorring endpoint differently. I did it without any issue.

not sure why you used dbo.sysfiles i/o sys.database_files.

David Levy mentioned in previous post "Yes, freeing the proccache will bring back the free space in tempdb temporarily. It will not shrink the file for you, but constantly growing...

You roughly need additional 1.2 time space of the biggest index. the .2 can go tempdb if you use SORT_IN_TEMPDB.

Yes, I am interested too.

how can you tell which process you want to kill from task manager?

---

My bad. I found pid. But I donot think you should kill this pid unless you have no...

Could you provide more details, such as partition key? Not sure what the staging table for. What data you were loading to that staging table?

Thanks.

put it simple. there is reason why it exists just like sqlclr. use it wisely it could be very useful component. do not limit youself.

It is just a story "close one door/open another door". If you use sproc to wrap xp_cmdshell, you control what the sproc can do. Keep in mind the sqlclr is...

I think that is your job to grant the permissions to the "remote user" on sql server side with what the user needs i/o "whatever".

Not sure what kind of security problem it could be if you use it properly, say use proxy account.

have you tried to add -QueryTimeout

when using invoke-sqlcmd?

I think you can try to

create clustered index with DROP_EXISTING clause.

Therefore you can proceed w/o drop FK.

I had installed 3 instances on 3+1 windows 2008 Clauster. License key is integrated. I do not know how to remove the license key. But I had no problem to...

Looking forward to seeing the scripts.