Thursday 22 August 2013

Finding the Size of INDEX on Specific TABLE in SQL SERVER

use Northwind
SELECT object_name(object_id) as TableName, *
FROM sys.indexes

--Syntax
exec sp_spaceused 'TableName'

-- Check the size of index
exec sp_spaceused 'Employees'

No comments:

Post a Comment