The heap tag has no wiki summary.
11
votes
1answer
173 views
What are valid usage scenarios for HEAP tables?
I am currently doing some data imports into a legacy system and discovered that this system does not use a single clustered index. A quick Google search introduced me to the concept of HEAP tables and ...
3
votes
1answer
159 views
How do I automate converting heaps into clustered indexes?
I have around 40 tables in one of our production databases that, for varying reasons, where not created with a clustered index.
What is the best automated method for converting these heaps?
Since ...
3
votes
2answers
131 views
Heap size too large for data present
A SQL Server 2008 R2 Standard Edition database has a staging table with no indexes, eight varchar(50) and one varchar(255) columns, and 162,676 rows. I'd expect that this table shouldn't be much over ...
6
votes
1answer
491 views
Are there any performance benefits to using a hash table with no clustered index?
I have this table:
CREATE TABLE [dbo].[relatea] (
[mid] [varchar](16) NOT NULL,
[sid] [varchar](16) NOT NULL
)
It stores hash matches. Is there any benefit to having this as a heap? It has ...
4
votes
1answer
94 views
SQL Server - is it ok to store link table as a heap?
I'm trying to understand if it's a good practice to have non-clustered PK on link table:
CREATE TABLE table1_table2(table1_id INT NOT NULL, table2_id INT NOT NULL,
CONSTRAINT PK_T1_T2 PRIMARY KEY ...
9
votes
3answers
233 views
Are heaps considered an index structure or are they strictly a table structure without index?
Inspired by this post: https://twitter.com/#!/SQLChicken/status/102930436795285505
Heaps: Are they considered an index structure or are they strictly a table structure without index?
