Volatile Temporary tables
Write down a short note on the Volatile Temporary tables (VTT).
Expert
Volatile Temporary tables (VTT):
a) Table Definition is stored in the System cache.
b) Data is stored in the spool space.
c) That is why, data and table definition both are active merely to session ends.
d) No collect stats for VTT.
Briefly describe the reason of synchronization function offered in Analysis Services 2005 ?
Explain the difference between ARRAY and STACK in Data Structures?
State difference between Passive and Active transformation?
States the term Mirror Activator Disk mirroring?
Give a brief introduction of the term Dimensional Modeling?
Write down the purpose of Fact-less Fact Table?
Write down the some of the important security characteristics of a DBMS?
Explain the term Super servers?
Illustrates the term data sparsity and how this effect upon aggregation?
Explain the Expression transformation?
18,76,764
1937378 Asked
3,689
Active Tutors
1411861
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!