Red Hat Linux cheat sheet commands examples RHEL

Useful Linux Commands (Red Hat)

(http://www.cse.buffalo.edu/~eisner/DLW) Revised 3/1/2000

Getting information man commandname display the manual page for a particular command named commandname man -S sectionnumber commandname display the manual page under a specific section numbered sectionnumber for the command named commandname. Sometimes the same command will exist in more than one section. man alone will . . . → Read More: Red Hat Linux cheat sheet commands examples RHEL

Howto: check database fragmentation sql server

Howto: check database fragmentation sql server

How to find all indexes that have fragmentation over 25%:

select * FROM sys.dm_db_index_physical_stats (NULL, NULL, NULL , NULL, ‘LIMITED’) WHERE avg_fragmentation_in_percent > 25.0 AND index_id > 0 AND page_count > 1000 order by avg_fragmentation_in_percent desc