Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2006
    Posts
    8

    Unanswered: How do u clear Cache in SQL

    How do u clear Cache in SQL

    if i run a query once it takes 10 seconds and if i run the same query again it takes 1 second because it is cached. So i want to know how i can clear it because i want do some benchmarking on a query that is in cache

  2. #2
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    DBCC DROPCLEANBUFFERS

    and

    DBCC FREEPROCCACHE

    finally a straight forward question.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Why is the sky blue?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    it has something to with the sun bouncing off the stuff in the air i think. yes here it is...

    http://www.sciencemadesimple.com/sky_blue.html
    Last edited by Thrasymachus; 12-14-06 at 15:43.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  5. #5
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    Quote Originally Posted by Brett Kaiser
    Why is the sky blue?
    that's one I know!

    sunlight is scattered by the atmosphere predominantly by Rayleigh scattering, which is light scattering by electric dipoles. it's much stronger at higher frequencies (that is, the higher the frequency, the more light is scattered). It's actually quite a strong dependence, goes like freq^4.

    Since all the molecules in the atmosphere scatter the blue end of the spectrum much more strongly than the red, the sky is blue. It's bluest at 90 degrees between you and the sun because dipole scattering is strongest there.

  6. #6
    Join Date
    Jul 2009
    Posts
    3

    Thumbs up clearing the query cache in sql server

    Clearing the query cache in sql server is pretty simple. It helps you at the time of checking the query performance in sql server. I think the following article will help you to clear query cache in SQL Server.

    How to Clear Query Cache in SQL Server

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •