SQL Server,C# and VB sharing Codes

SELECT T.object_id
, T.Name 'HEAP TABLE'
FROM sys.indexes I
INNER JOIN sys.tables T ON I.object_id = T.object_id
WHERE I.type = 0
AND T.type = 'U'
ORDER BY t.name

Read this for more details. It will help you to boost your SQL Server Performance:

Heaps (Tables without Clustered Indexes) A heap is a table without a clustered index. One or more nonclustered indexes can be created on tables stored as a heap. Data is stored in the heap without specifying an order. Usually data is initially stored in the order in which is the rows are inserted into the table, but the Database Engine can...

What are the difference between DELETE and TRUNCATE?. Answer will be posted later in the comment box.

Goodevening Developers!
What is the difference between
DBA and DB Engineer? B-)

Happy Cold morning everyone :)