Tara-1044200 (9/22/2010)
both db's are completely identical(tables,strcutures,indexes etc..) except the amount of data.
Amount of data is a major factor in query plans.
Can you try a statistics update on the DB that's running slow?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability