SQL 优化经典

1.http://www.sqlhacks.com/Optimize/Optimize

 

例子 ：

1)Tempdb usage

1. SELECT CAST ( DB_NAME ( mstr.database_id ) AS VARCHAR ( 24 ) ) AS 'Database' ,
2.        CAST ( mstr.physical_name AS VARCHAR ( 72 ) ) AS 'File' ,
3.        stats.num_of_reads ,
4.        stats.num_of_bytes_read ,
5.        stats.num_of_writes ,
6.        stats.num_of_bytes_written ,
7.        stats.size_on_disk_bytes
8. FROM sys.dm_io_virtual_file_stats ( null,null) AS stats
9.          join sys.master_files AS mstr
10.               ON mstr.database_id = stats.database_id
11.                  and mstr.FILE_ID = stats.FILE_ID
12. WHERE DB_NAME ( mstr.database_id ) = 'tempdb' or
13.       DB_NAME ( mstr.database_id ) = 'sql911' ;
14. go

2.http://support.microsoft.com/kb/907877/zh-cn

 

3.http://msdn.microsoft.com/en-us/library/cc966540.aspx#EGAA