Consultas SQL server

0

Tamaño de tablas

SELECT 
        t.NAME AS NombreTabla,
        s.Name AS Esquema,
        p.rows AS NumFilas,
        SUM(a.total_pages) * 8 AS EspacioTotal_KB, 
        SUM(a.used_pages) * 8 AS EspacioUsado_KB, 
        (SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS EspacioNoUsado_KB
FROM 
        sys.tables t
INNER JOIN      
        sys.indexes i ON t.OBJECT_ID = i.object_id
INNER JOIN 
        sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
INNER JOIN 
        sys.allocation_units a ON p.partition_id = a.container_id
LEFT OUTER JOIN 
        sys.schemas s ON t.schema_id = s.schema_id
WHERE 
        t.NAME NOT LIKE 'dt%' 
        AND t.is_ms_shipped = 0
        AND i.OBJECT_ID > 255 
GROUP BY 
        t.Name, s.Name, p.Rows
ORDER BY 
        EspacioUsado_KB desc

Creación de indices

CREATE INDEX nombreindice
ON nombretabla (nombrecolumna)

CREATE INDEX ExistenciaOrdenes
ON ordenes(email, idsku, created_at )

Consulta de indices en tabla

sp_helpindex '[dbo].[ordenes]'

Constraints

ALTER TABLE dbo.maximo_y_minimos  
ADD CONSTRAINT AK_max UNIQUE (email, idsku);   

SELECT *
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE TABLE_NAME = 'maximo_y_minimos'