Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
3 Cards in this Set
- Front
- Back
Sparse Column |
SPARCE clause set to 1 will allow zero or null values to take up less space Good where large percentage of rows are empty for a column Can fit in a filtered index, but not clustered index Putting in a non-clustered index will not be optimum for space due to it's large amount of empty rows |
|
What is the maximum limit of a SPARSE column |
100,000. All the SPARSE columns does not count to this limit of 1024 set in SQLServer 2008 |
|
Row Compression has no affect on type text columns. True/False |
True |