term1 Definition1term2 Definition2term3 Definition3
Please sign in to your Google account to access your documents:
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
Need help typing ? See our FAQ (opens in new window)
Please sign in to create this set. We'll bring you back here when you are done.
Discard Changes Sign in
Please sign in to add to folders.
Sign in
Don't have an account? Sign Up »
You have created 2 folders. Please upgrade to Cram Premium to create hundreds of folders!