0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for music historians, critics, and fans

SET STATISTICS IO ON
GO
/*SELECT OBJECT_NAME(i.OBJECT_ID) AS TableName, i.name AS IndexName, i.index_id AS IndexID, 8 * SUM(a.used_pages) AS 'Indexsize(KB)', (8 * SUM(a.used_pages)) / 1024 AS 'Indexsize(MB)'
FROM sys.indexes AS i
INNER JOIN sys.partitions AS p ON p.OBJECT_ID = i.OBJECT_ID AND p.index_id = i.index_id
INNER JOIN sys.allocation_units AS a ON a.container_id = p.partition_id
WHERE OBJECT_NAME(i.object_id) = 'PostHistory'
GROUP BY i.OBJECT_ID, i.index_id, i.name
ORDER BY 5 DESC --OBJECT_NAME(i.OBJECT_ID), i.index_id
GO
SP_SpaceUsed @objname = 'PostHistory'

*/

SELECT Text FROM PostHistory TABLESAMPLE (10 ROWS)

fork query

edited jul 17 19

created jul 16 19 anonymous