SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Augusto Alfonso

SQLServerCentral.com profile

   Items 1 to 2 of 2   
 

Check Fragmentation on All Indexes on Database

In this script we create a temporal table and then review all indexes with next conditions. avg_fragmentation_in_percent > 10 % or avg_page_space_used_in_percent > 90 %   Read more...
By Augusto Alfonso 2008/09/03 | Source: SQLServerCentral.com | Category: index management
Rating: |  Discuss |  Briefcase | 3,239 reads

Numero de Registros y espacio usado en disco

Generacion de numero de registros y espacio usado en disco todas las tablas de la base de datos  Read more...
By Augusto Alfonso 2008/08/22 | Source: SQLServerCentral.com
Rating: |  Discuss |  Briefcase | 416 reads
   Items 1 to 2 of 2