How can I clear the SQL Server query cache?

by

Here is some good explaination. check out it.

http://www.mssqltips.com/tip.asp?tip=1360

CHECKPOINT; 
GO 
DBCC DROPCLEANBUFFERS; 
GO

From the linked article:

If all of the performance testing is conducted in SQL Server the best approach may be to issue a CHECKPOINT and then issue the DBCC DROPCLEANBUFFERS command. Although the CHECKPOINT process is an automatic internal system process in SQL Server and occurs on a regular basis, it is important to issue this command to write all of the dirty pages for the current database to disk and clean the buffers. Then the DBCC DROPCLEANBUFFERS command can be executed to remove all buffers from the buffer pool.

More Related Contents:

  1. How to split a comma-separated value to columns
  2. Get a list of dates between two dates using a function
  3. What is the use of GO in SQL Server Management Studio & Transact SQL?
  4. Cannot resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AS” and “Latin1_General_CI_AS” in the equal to operation
  5. Import Multiple CSV Files to SQL Server from a Folder
  6. Confused about UPDLOCK, HOLDLOCK
  7. Retrieve column definition for stored procedure result set
  8. SQL Server Random Sort
  9. SQL Server database backup restore on lower version
  10. Add a new table column to specific ordinal position in Microsoft SQL Server
  11. How to update large table with millions of rows in SQL Server?
  12. How do you specify a different port number in SQL Management Studio?
  13. Export table to file with column headers (column names) using the bcp utility and SQL Server 2008
  14. Sequence as default value for a column
  15. How to set monday as first day of week in SQL Server
  16. How do I flush the PRINT buffer in TSQL?
  17. SQL Server Login error: Login failed for user ‘NT AUTHORITY\SYSTEM’
  18. VarBinary vs Image SQL Server Data Type to Store Binary Data?
  19. Drop primary key using script in SQL Server database [duplicate]
  20. OR Operator Short-circuit in SQL Server
  21. Need help in calculation using two Datasets using Expression SSRS
  22. T-SQL XOR Operator
  23. SQL Server: convert ((int)year,(int)month,(int)day) to Datetime [duplicate]
  24. Bulk insert fixed width fields
  25. What does the SQL # symbol mean and how is it used?
  26. Restore a SQL Server 2000 backup on SQL Server 2012
  27. Connect to SQL Server through IP address
  28. Why would using a temp table be faster than a nested query?
  29. SQL Server 2008 Spatial: find a point in polygon
  30. Does Microsoft OLE DB Provider for SQL Server support TLS 1.2

Leave a Comment