SQL server tutorials
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment