Glad to see the dumps group has arrived. The primary reason I don't tend to bother with the exams anymore, its such a shame to see such a useful tool...

alphabetical

Have you checked the wait stats on both boxes ? might give you an idea of whether there is something connected to the hardware or the processing methods used.

I could quite legitimately say I have construction and building experience if you include Lego....

Great article, my experience is you learn for more and far more quickly in a crisis than at any other time. Amazing how stress and the constant management badgering lead...

But if that's the case Bill then Filtered Indexes are a breach in the philosophical argument. Maybe even the space time continuum...

You'll need to GRANT the correct priviledge to the user of that database

USE AdventureWorks; 
GRANT CREATE TABLE TO RichardM; 
GO

This is where I...

Also are you running Full text Search or anything like that as this can have an impact on the virtual memory settings. If I remember rightly the Virtual memory is...