Useful SQL Server DBCC Commands

http://www.sql-server-performance.com/dbcc_commands.asp
good dba tips on how to optimize queries


to clean the cache in sql query analyzer:
CHECKPOINT
DBCC DROPCLEANBUFFERS