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
Explain about the file stream storage of sql server 2008?
Illustrates the policy based administration feature of SQL Server 2008?
Define the Notification services.
What are the fundamental tools of Notification services?
How do you control the maximum size of a HEAP table?
How would you enter Characters as HEX Numbers?
What is the Window PowerShell snaps SQL server provided?
What are the primary keys of database programming?
What is the difference between BLOB and TEXT?
Explain about encryption of whole databases without the requirement for application changes in SQL server 2008.
18,76,764
1956882 Asked
3,689
Active Tutors
1442359
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!