Query Analyzer Slow - Management Studio Fast
Hi
If I run a simple "select top 10000 * from table" query against a SQL
2005 server from a client pc using management studio the query returns
in about a second. Running the same query on the same client pc using
the older query analyzer takes 25 seconds.
Does anyone know why/how this could happen ?
Do the two applications connect to SQL using different mechanisms ?
(Both QA and MS connect using windows authentication)
Regards
Clint.
|