Meaning of Heap tables
What do you mean by Heap tables? And also define its characteristics?
Expert
a. HEAP tables are found in memory.
b. HEAP used for high speed storage on temporary basis.
Their characteristics are as follows:
a. They do not allow BLOB or TEXT fields.
b. Only comparison operators like =, <,>, = >,=< , can be used with them.
c. HEAP tables does not support AUTO_INCREMENT
d. Indexes should be NOT NULL
Define the term sparse column sets.
Illustrates commands BREAK and COMPUTE?
Explain about the extended events within sql server 2008.
What are the unique keys of database programming?
Illustrates the term Correlated Subquery?
What are the requirements for Hot Add CPU?
Describe the term sparse filtered index.
What are the new capabilities of SQL server 2008 for persisting BLOB data?
What are included in SQL Server 2008 for automatic auditing?
Illustrates the policy based administration feature of SQL Server 2008?
18,76,764
1957225 Asked
3,689
Active Tutors
1415576
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!