Yes, DBCC FREEPROCCACHE
-----Original Message-----
From: David.Ekren [mailto:mssqldba-ezmlmshield-x14683393.[Email address protected]
Sent: Monday, March 31, 2008 10:51 AM
To: LazyDBA Discussion
Subject: Comparing SQL times
I am running different queries in SQL Analyzer that all get the same
result sets, but with different indexes and different t-sql. Do I need
to clear the query cache or anything between running these queries to
make sure I am compare the execution times correctly? This is SQL 2000.
Thanks in advance,
David
****************************************************************
The information contained in this E-mail and any of its
attachments is intended only for the use of the address(es)
indicated above, and is confidential. This information may
also be legally privileged. If you are not the intended
recipient(s), you are hereby notified that any dissemination,
review or use of the information contained herein is
strictly prohibited. You may not copy, forward, disclose or use
any part of this information. If you have received this
information in error, please delete it and all copies from your
system and notify the sender immediately by return E-mail.
Thank you.
Internet communications are not always timely or
secure, and can contain errors and viruses. The sender does not
accept liability for any errors or omissions which arise as a
result.
****************************************************************
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Disclaimer: This e-mail message is intended only for the personal use of
the recipient(s) named above. If you are not an intended recipient, you
may not review, copy or distribute this message. If you have received this
communication in error, please notify us immediately by e-mail and delete
the original message.
This e-mail expresses views only of the sender, which are not to be
attributed to Rite Aid Corporation and may not be copied or distributed
without this statement.
MS Sql Server LazyDBA home page