This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In this post, I am sharing a script for a Database Administrator to find SQL Server Heap Tables which are not having a clustered index.
A Table without a clustered index is called as Heap Table and Data is stored in the Heap without specifying an order.
Sometimes, database developer forgets to apply cluster index on a particular table and after that, the same table may have a lot of data which affect the query performance without having a clustered index.
Below is a script:
OBJECT_NAME(object_id) AS TableName
,type_desc AS TableType
WHERE index_id = 0