No, that's the definition of a copy_only backup.

Huh? Don't understand the question.

Yes.

Recompile allows, among other things, variables to be 'parameter sniffed'. That can be enough to start the optimiser searching in a different area of the plan space, resulting in a...

Can you expand the drive?

Is that the only message?

Can you move files off S drive to free up space?

What are the messages in the error log?

Inline Table-valued functions are. Specifically inline, not...

The physical joins are the actual implementation options that SQL has. You say INNER JOIN or LEFT OUTER JOIN or whatever other logical join you need in the query, the...

Which is Qui-gon Jinn from the Star Wars movie The Phantom Menace.

It doesn't look all that useful. However what time frame does that index usage stats data cover?

T-SQL has no join constructs like that.

Oracle (iirc) has a NATURAL JOIN which joins on the foreign key columns, but SQL Server doesn't have that

No. Fragmentation of an index is a measure of how much the logical order and physical order of an index differ. It's caused by page splits and database shrink operations.

You could use KILL on them, but why? Do you know the impact of killing those connections? Do you know if the apps will handle that?

Maybe I'm missing something, but the way I did it (SQL 2005)...

You tell because there will be an error in the error log saying that the snapshot couldn't be created and that CheckDB is attempting to take table locks. It's pretty...