SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 815 Page Views: 

What do you mean by Heap Table?



Posted By: Avi Date: 1 October 2010 12:23:08 PM
 Answer:

These are the tables without clustered Indexes and possses one row in sys.partitions with index_id=0. Generally Heap Tables are single partitioned, but if they have multiple partitions then each partition is a heap.


Posted By: avibtech

Date: 1 October 2010 12:23:08 PM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image fDBoDJ
Related Questions
SQL Server : What is the purpose of SET NOCOUNT ON?

What is the purpose of SET NOCOUNT ON?

Whenever a Select Statement or any DML Statement is executed the server return a value that is the n....
Category: SQL Server Date: 10/1/2010 12:07:08 PM
SQL Server : What are distributed Queries?

What are distributed Queries?

Distributed Queries are the queries which can access multiple hetrogeneous data from different sourc....
Category: SQL Server Date: 10/1/2010 12:06:08 PM
SQL Server : When do the database checkpoints occur?

When do the database checkpoints occur?

Check point will occur in the following cases:- 1. It can be added manually . The Syntax is:- CHEC....
Category: SQL Server Date: 10/1/2010 12:05:08 PM
SQL Server : What is the purpose of the checkpoint?

What is the purpose of the checkpoint?

Whenever an operation is performed in SQL Server it is not committed directly to the database.All th....
Category: SQL Server Date: 10/1/2010 12:04:08 PM
SQL Server : What do you mean by dirty pages in SQL Server?

What do you mean by dirty pages in SQL Server?

Dirty pages in SQL server are the data pages which have been modified and are still lying in the buf....
Category: SQL Server Date: 10/1/2010 12:03:08 PM
 
Signup for our weekly email newsletter
email newsletter
Questions Categories