Question : i recently found out that one heap table had more than 70% fragmentation. So i decided to do […]
Tag: heap
Bitmap Heapscan is slow
Question : I have 2 tables: mailings and form_responses. The form_responses table has a foreign key with the mailings table, […]
MSSQL: High number of logical reads when inserting into fragmented heap
Question : I’m inserting a batch of rows – using INSERT INTO tblUploadBanking SELECT FROM … – into a table, […]
How much does an ordered query of an attribute costs in terms of operations when the attribute is a key or an attribute?
Question : How much does the following query costs in terms of operations when the attribute is a key or […]
Forwarding records in #temp table
Question : I have a temp table which I update many times based on joins (each time almost all the […]
Benefits of not having a clustered index on tables (heaps)
Question : What are the benefits of not having a clustered index on a table in SQL Server? Will: SELECT […]
Heap size too large for data present
Question : A SQL Server 2008 R2 Standard Edition database has a staging table with no indexes, eight varchar(50) and […]
What happens when you change a heap into a clustered table in SQL Server?
Question : As I understand, a heap is an unordered object. When you insert a record, SQL Server use IAM […]
Bitmap Heapscan is slow
Question : I have 2 tables: mailings and form_responses. The form_responses table has a foreign key with the mailings table, […]
Fix SQL Table with *BOTH* Heap AND Clustered Index
Question : Somehow, we have a SQL Server Table with both a HEAP and a CLUSTERED index on a table. […]
- 1
- 2