Sparse columns of sql server 2008
Explain about the sparse columns of sql server 2008.
Expert
A column along with an optimized storage for null values is termed as sparse column. Sparse columns decrease the storage space requirements for null values. Within a scenario of saving 20 percent to 40 percent of storage space, sparse columns can be seemed. They are created by using CREATE or ALTER TABLE statement.
A huge number of user defined properties can be accessed with using sparse columns and filtered indexes allowed applications like Share Point Services of windows are efficiently access and store.
What is BLOB?
Illustrates the term External Key Management in SQL server 2008?
Explain about encryption of whole databases without the requirement for application changes in SQL server 2008.
What is TEXT?
Describe the Hot Add CPU in sql server 2008.
Define the term sparse column sets.
Explain about the Entity Data Services within sql server 2008.
What is the difference between BLOB and TEXT?
Give the advantages of MySQL in comparison to Oracle?
Define the SQL*Plus briefly.
18,76,764
1932959 Asked
3,689
Active Tutors
1443689
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!