Hi gang, I've got a problem I can't seem to find an answer for after googling around for a short while. The problem is one of performance and linked servers.
Some developers have been implementing full outer joins, possibly by mistake; In profiler I can see the error events "Missing Join Predicate". However, it returns me only the application name and the spid. Clearly, it would be interesting to find the queries or procedures that are ...
Hi Gang, I'm working in a scenario where a 2000 database is being migrated to 2005. We've backed up the 2000 db and restored it on 2005, and are now noticing some perf issues with selected queries in a parallel test that's currently