It's hard to know what else you can do without seeing some code and data. I would agree a cursor is not needed. You ought to be able to update...

This might help: https://dba.stackexchange.com/questions/171204/sql-server-informix-db-linked-server

There are a few things with that. First, we focus on SQL Server, so we want to host on SQL Server.
Second, there are things we do that can be...

We've published things a few times, but not anything in awhile. Our system is fairly simple, but it's probably worth documenting. We do have the stats live at

There are lots of people on 2005/2008. In fact, one of the surveys I saw a few months back noted that 2008 is one of the most installed versions. Lots...

Should but don't.

I don't. I've never used that system, but most technologies have quick text exports.

I would suggest exporting from Cache to text and then importing with bcp/BULK INSERT. Those items would probably work better for you.

Check the Windows error logs. Looks like something with SQL Server won't start.

Also, in the SQL Server install folders, there's a /log folder. Look for the errorlog that...

You haven't provided any information here.
Don't use the title, but describe the problem and errors in detail, along with what "tricks" you have used. Otherwise we may end up...

You should do some research to try and understand. Us answering these questions for an interview doesn't help you or an employer. If you have specific questions on any of...

Congrats!

You'd need a way to measure the disk udsage for all VMs/processes at the same time. When you have a hypervisor in the way, it's possible that other processes are...