Afficher un message
Vieux 31/03/2008, 11h15   #1
Clint Good
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut 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.
  Réponse avec citation
 
Page generated in 0,05285 seconds with 9 queries