Can someone explain the use of DBCC DROPCLEANBUFFERS
together with the CHECKPOINT
operator and provide an example?
I understand it is useful to test performances running before your queries but I don't fully grasp it. Also I have no clue about the use in combination with the CHECKPOINT operator.
If I execute it before my queries they take much longer to run, so I am guessing it is good to compare performances but not to accurately evaluate them.
Any help would be appreciated!