Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Augusto Alfonso

SQLServerCentral.com profile

   Items 1 to 3 of 3   
 

Finding all Columns of an Index

This script helps to find all columns of an index on a table. Include columns covered (include)  Read more...
By Augusto Alfonso 2011/06/17 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,269 reads

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: indexing
Rating: |  Discuss |   Briefcase | 4,300 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 | Category: size database
Rating: |  Discuss |   Briefcase | 496 reads
   Items 1 to 3 of 3