Comparing Tables Organized with Clustered Indexes versus Heaps

(Burzin Patel and Sanjay Mishra) In SQL Server 2005, any table can have either clustered indexes or be organized as a heap (without a clustered index.) This white paper summarizes the advantages and disadvantages, the difference in performance characteristics, and other behaviors of tables that are

Read More - Register for Free Membership