I don't know which tool you're referring to. However, the command there is running an attach from an MDF and an LDF. You can't attach from a .BAK. You can...

Yeah. You'll have to correlate in the IDs. A SPID can, and should, be reused, so without the time correlation, this spid, at this time, you can't make a direct...

Let's start with this:

Both are evil!

That out of the way, you can only use NOLOCK by modifying code. You can use READ UNCOMITTED by changing...

Oh. My.

I will not be participating in that conversation. Neither as Grant nor as the PASS President. Woof! Y'all have fun.

Ah, tracked down a copy of the reports possible in the HP thing:

Active Connections • Database Status • Filegroup Space Usage • Locks Wait Rate • Microsoft SQL...

I've never seen HP OMI SQL Server Management Pack in action. I went to the HP documentation, but the page won't load, so I can't comment on any...

DECLARE is for creating local variables. These are different from parameters. Both start with @, but are treated differently within the engine, therefore different mechanisms for definition.

1) Yes.
2) Not really. Rebuilding indexes, probably something you'd want to do after data loads, will defragment the data storage internally, moving everything to one area of the file....