Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning sp VS adhoc query peformance? RE: sp VS adhoc query peformance?
Ian Yates
SSCoach
Points: 19738
More actions
February 10, 2008 at 6:22 am
#776731
Silly question, but how much more data do you have in production compared to your test environment? Is your test data obviously fake test data such as lots of similar names, etc?