That's an indication the optimizer thought that operator would be executed 200 times. It may or may not be depending on the accuracy of your statistics. You can run the...

Without the plan itself, not just a picture, it's really hard to say. Can you post the execution plan? An actual plan would be preferable to an estimated one.

You might also want to look up sp_whoisactive by Adam Machanic.

Assuming you're talking about two different server instances and two different sets of file locations so that each server is pointing to a different file, the names don't need to...

And chances are really good if you don't have a DBA around that there are statistics inside the databases that need to be updated, there may be query tuning opportunities,...

There are two kinds of execution plans, estimated and actual. To get an estimated plan inside SQL Server Management Studio, you simply type:

EXEC myNewProc 'myparameter';

Highlight that command and within Management...

Microsoft and the Books Online are our bestest friends in the world.

No, it should work on 2012. It would have been a good idea to get the entire message and everything that it said is incompatible. But according to Microsoft, it's...

I forgot about PowerShell. You need to enable permissions to that in addition to giving them the access to the locations of the backups. I'd also enable remoting for PowerShell....

Probably not much needed at all most of the time. You do need access to the file system to look at the backup files and any other load or...

I'm back where I was. I'd break it down into three tables, one to define the owner, one to define the competency and one to relate them to each other.

I trust Perry on the structural side of things like this. If he says you literally can't do it, you probably can't. I'm pretty much in the camp of I...

Generally, because of how SQL Server stores and retrieves data, it's a good idea on most tables to have a clustered index. Because of how clustered indexes are stored, it's...

If they're low on space, yeah, I'd turn on auto grow, or maybe just go ahead and give them some head room now if you have the disk space to...

Nice job figuring it out. And thanks for posting the solution so anyone else who finds the question knows what you did to solve it.