tiny hair extensions what is european hair type simply wigs best human hair extensions no clip hair toppers human hair extensions hair rehab discount code 2018 school hair bobbles hair extensions micro bead hair extension starter kit jaipur hair extensions reviews real hair extensions black natural hair mohawk styles best oil for hair loss and regrowth lace wigs
maio | 2013 | Inove Tecnologia

Arquivos Mensais: maio 2013

Script para mostrar o tamanho das tabelas MSSQL

Script muito útil para mostrar o tamanho das tabelas no MSSQL. Ele cria uma tabela temporária válida somente para a janela da Query executada.

SELECT OBJECT_NAME(ID) TABELA, CONVERT(DEC(15),SUM(RESERVED)) RESERVED
INTO #X
FROM SYSINDEXES
WHERE indid in (0, 1, 255)
GROUP BY ID

SELECT TABELA, LTRIM(STR(RESERVED * D.LOW / 1024., 15, 0)) + ' KB'
FROM #X, master.dbo.spt_values d
where d.number = 1
and d.type = 'E'
ORDER BY RESERVED DESC

Link original