POWER function , DBCCSHOWCONTIG.

POWER function - is straight forward - gives you the power value of a value.
DBCCSHOWCONTIG - a very good piece of code -

USE AdventureWorks2012;
GO
DECLARE @id int, @indid int
SET @id = OBJECT_ID('Production.Product')
SELECT @indid = index_id
FROM sys.indexes
WHERE object_id = @id
   AND name = 'AK_Product_Name'
DBCC SHOWCONTIG (@id, @indid);
GO

References :

http://msdn.microsoft.com/en-IN/library/ms174276.aspx - POWER
http://msdn.microsoft.com/en-us/library/ms175008.aspx - DBCC SHOWCONTIG.