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....

It's extremely situational. It depends on your region of the world, the services you offer, your level of experience, your level of reputation, and finally, whatever the market will bear....

Please don't cross post questions. It makes the conversation difficult to keep track of.

I posted one answer over here. Please, anyone else, continue the conversation there.