Microsoft SQL Server Hosting : Slow query missing indexes?

Finding a good web host for your database sites is a big problem. Check our recommended host for database hosting or the datacenters with the most powerful and reliable dedicated servers suited for large databases.

This databases discussion was started by paul_anthony 0n 24 November 2008

I’ve a query that runs on two different machines with two different result. One machine it takes 12 seconds – the other it is almost instant. I think perhaps I have missing indexes on one server – anyone any advice on speeding the query up?

Alternatively any tools for mirroring database setups would be useful. Would the output of the execution plan make any sense to anyone?

I’ve attempting to script the indexes / primary / foreign keys between the two – to no avail.

Really tearing the hair out now as to where the bottle neck is.

Learn more Microsoft SQL Server databases here. Should you need to go for trustworthy hosting services for all database related sites, we suggest this host for virtual database hosting and this one for dedicated databases hosting