When I rewrote the query as follows: select * from table1 t1, table2 t2, relationships t3, table4 t4 WHERE ( (t1.id = t4.id1) AND ( t1.id = t3.id ))...
I am having a performance issue with a SQL join query. The database has 50K objects and 15000 relationship objects. Here is the query: select *...
I used the MAXDOP 1 OPTION but it did not affect the performance results. What is ITW?
They are both 32 bit machines. Memory settings are the same. However, I just reserved another testing machine which was not a Quad but a Dual-core...
Yes, I was thinking about I/O as a bottle neck but shouldn't there be the same bottleneck when running the query remotely? The remote query ran as...
Thanks for your advice. Unfortunately, I don't have access to the quad machine at the moment to try out your solution. But I did configure SQL Server...
The query plan on both machines are identical. The configuration settings for parallelism on both machines are also identical.
I run a TSQL query using SQL Management Studio and have noticed the performance is significantly degraded when running on a 4-processor (quad)...
Separate names with a comma.
