I have two servers, Production and Development, that are identical in hardware and setup, although the execution plans are different. A query that I run on the Production server takes 3 seconds to complete; the same query on the Development server takes 66 seconds! I've tried everything I can think of to troubleshoot the slowdown, including using DBCC INDEXDEFRAG, DBCC DBREINDEX, and DBCC SHOWCONTIG. Please advise.
...