Home‎ > ‎

Handy Scripts

The following is a list of my most useful scripts.  Feel free to take a look at them and tell me what you think.  Donation accepted via paypal.
Showing 3 items
CatagoryScript NameDescription
Sort 
 
Sort 
 
Sort 
 
CatagoryScript NameDescription
Index Maintenance sp_defrag_indexes Run daily to reindex or rebuild indecies depending on fragmentation level 
Compression Compress All Tables Requires Enterprise Edition 
Performance Tuning ShowMemory Shows a breakdown of sql server memory by database 
Showing 3 items
ċ
CompressAllTables.sql
(2k)
x y,
Nov 30, 2011, 12:50 PM
ċ
ShowMemory.sql
(2k)
x y,
Nov 30, 2011, 1:36 PM
ċ
sp_Defrag_Indexes.sql
(19k)
x y,
Nov 30, 2011, 12:32 PM
Comments