I have run a profiler trace to capture any query with more than 1,000,000 reads and have captured a number of them but none of the run times are anywhere...

Yes - clicked on Advanced button for both Web Service URL and Web Portal URL. In the Advanced Multiple Web Site Configuration dialog, clicked Add, selected Host Header Name, entered...

Can the default URL and the test one use the same port - 80 in this case?

The service restarts inside the config manager when the URLs are created but have also restarted outside the config manager.
The original URL (eg http://<servername>/Reports) works fine but the...

To use Monty Python's Holy Grail as a metaphor, every major effort in a database requires a 'run away' option.

I think some context is missing from the statement.

The statement says that if Total Memory is significantly and consistently less than Target Memory then there is memory pressure. This would...

Every SQL book I ever read or course I ever took had somewhere in it the admonition to avoid cursors wherever possible. Back in the dawn of SQL time (talking...