Rob,

The difference in query plans could be two fold. After the system parsing takes place on a query for syntax etc. it then binds the objects and creates...

Rob,

To summarize your system here is what I have gathered so far:

RamRaid QuantityBreak down

Lab32GBRaid 1-04OS,Trans,DWH,Logs

Prod24GBRaid 1-04OS,Trans,DWH,Logs

Things we don’t know

•Is it on a SAN

•Processor Types and Cores Identical?

•Maximum Memory

•Minimum...

Rob,

Do you have SQL Sentry or SQL Monitor in place? Your post regarding backups jogged my memory of a simlar situation with one of my production environments where...

Rob,

I know the end of the rope feeling so I thought I would at least try to help out. I'm assuming at this point you have double or...