Heap

What is Heap table in SQL Server and How to get all the heap table from a database ? TIP # 54

  Heap table:- A table without cluster index is called Heap table. Now you are thinking why we are talking about this. So as  SQL developer we should aware and In next post I will explain which is related to maintenance how to Rebuild a heap table. Now our next question is how to determine …