Hi
How can you find Tables without Indexes . How do you find Index size of a Table ?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Anil KumarPosted Jun 5, 2012, 8:47 AM
EXECUTE sp_spaceused <My_Table_Name>
Anil KumarPosted Jun 5, 2012, 8:37 AM
SELECT [name] AS Tables_Without_Indexes
FROM sys.tables
WHERE OBJECTPROPERTY(OBJECT_ID,'IsIndexed') = 0
ORDER BY 1;
brunda kPosted Jun 5, 2012, 8:29 AM
http://sqlblog.com/blogs/davide_mauri/archive/2010/08/09/find-all-the-tables-with-no-indexes-at-all.aspx