Last active
August 29, 2015 14:24
-
-
Save Fhernd/3e7503f95d0dbea09599 to your computer and use it in GitHub Desktop.
Muestra la información de espacio de uso de las tablas de la base de datos AdventureWorks.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- OrtizOL - xCSw - http://ortizol.blogspot.com | |
-- Declaración de variables: | |
DECLARE @TablasAdventureWorks TABLE (SchemaTable varchar(100)); | |
DECLARE @NombreTabla varchar(100); | |
-- Inserta los nombres de las tablas en la tabla @ATablasAdventureWorks: | |
INSERT @TablasAdventureWorks (SchemaTable) | |
SELECT TABLE_SCHEMA + '.' + TABLE_NAME | |
FROM INFORMATION_SCHEMA.tables | |
WHERE TABLE_TYPE = 'BASE TABLE' | |
ORDER BY TABLE_SCHEMA + '.' + TABLE_NAME; | |
-- Reporte de espacio usado por cada table con el | |
-- el procedimiento almacenado `sp_spaceused`: | |
WHILE (SELECT COUNT(*) FROM @TablasAdventureWorks) > 0 | |
BEGIN | |
SELECT TOP 1 @NombreTabla = SchemaTable | |
FROM @TablasAdventureWorks | |
ORDER BY SchemaTable; | |
EXEC sp_spaceused @NombreTabla; | |
DELETE @TablasAdventureWorks | |
WHERE SchemaTable = @NombreTabla; | |
END; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment