Yes, looks like you need to look deeper. Either that first INSERT is not doing what you think it does, or something else is deleting rows from that table.

You could...

A key here is:...

Without looking or testing, I would assume that the value you see in exec_procedure_stats is when the procedure originally was compiled, but in query stats you see the recompilation times...

In XQuery (which is what you should use):

DECLARE @x xml = '<bookstore>

<book>

<title lang="eng">Harry Potter</title>

<price>29.99</price>

</book>

<book>

...

We don't know what's in those transactions so it is hard to tell. But CATCH handler looks wrong. Why would you commit if you get an error? Shouldn't you always...

with tmp as (

select x = 'some text-1'

union select x = 'some text-123'

union select x = 'some text-123.4'

union select x...

I have had my battle with the BOL folks... I can live with the installation, and if you install VS2012, you get a Help Viewer that is somewhat better.

But I...

I played some with Wireshark (which I don't have any previous experience of) and I was able to confirm your findings. I did not analyse whether all packets are DONE...

/PAE is needed to be able to use AWE. However, not always. Books Online says:

In Windows Server 2003, PAE is automatically enabled only if the server is using hot-add memory...

Exactly how did you conclude that you got those DONE packets even with SET NOCOUNT ON? I spoke with Jonathan Kehayias, and he ran a test with Wireshark, and he...

Dropping and recreating foreign keys every three months is not defensible. Recreating the FKs takes just as long time as takes to perform the check for the DELETE.

I suggest that...

Interesting. That would indicate a difference between stored procedures and loose batches that I was unaware of.

Earlier you said that it did not install, and you could not uninstall it. Now you are saying that extraction doesn't work? Why on Earth would try to uninstall something...

Is /PAE present in BOOT.INI?

Can you post the output of this batch:

select physical_memory_in_bytes, virtual_memory_in_bytes,bpool_committed, bpool_commit_target, bpool_visible

from sys.dm_os_sys_info

EXEC sp_configure 'show advanced options', 1

RECONFIGURE

EXEC sp_configure 'awe enabled'

EXEC sp_configure 'max server memory'

So the problem is exactly the foreign keys. CASCADE or NO ACTION, if you delete a row from a table, and there is an FK constraint from a big table...