Saturday, 14 November 2009
Installing Oracle Database 11g on Windows
http://www.oracle.com/technology/software/products/database/index.html
Installation instructions:
http://www.oracle.com/technology/obe/11gr1_db/install/dbinst/windbinst2.htm#i
Tuesday, 10 November 2009
Rapidshare Download Tools
Monday, 9 November 2009
Clean Buffers and Free Cache
DBCC DROPCLEANBUFFERS: Use this command to remove all the data from SQL Server’s data cache (buffer) between performance tests to ensure fair testing. Keep in mind that this command only removes clean buffers, not dirty buffers. Because of this, before running the DBCC DROPCLEANBUFFERS command, you may first want to run the CHECKPOINT command first. Running CHECKPOINT will write all dirty buffers to disk. And then when you run DBCC DROPCLEANBUFFERS, you can be assured that all data buffers are cleaned out, not just the clean ones.
DBCC FREEPROCCACHE: Used to clear out the stored procedure cache for all SQL Server databases. You may want to use this command before testing to ensure that previous stored procedure plans won’t negatively affect testing results.
The cache can be cleared with the following script:
CHECKPOINT;
GO
DBCC DROPCLEANBUFFERS;
GO
DBCC FREEPROCCACHE;
GO