Test db only.

With one table where is just one record.

create table test (test int);

go

insert test select 1;

My question is:

How to completely clear buffer pool (same state as when...

Hi, thank you for comment,

but it is not clear for me.

I did dbcc dropcleanbuffers;

and after that the data won't be in the buffer pool?