By egenesky
via c-sharpcorner.com
Submitted: Feb 10 2013 / 15:14
A SPARSE column is an ordinary type of column that has optimized storage for NULL values. It also reduces the space requirements for null values at the cost of more overhead to retrieve non-null values. In other words, a SPARSE column is better at managing NULL and ZERO values in SQL Server. It does not occupy any space in the database. Using a SPARSE column we may save up to 20 to 40 percent of space. We can define a column as a SPARSE column using the CREATE TABLE or ALTER TABLE statements.
-
Spring from the Trenches: Adding Validation to a REST API
-
How to Handle Complex Computing for Excel Users without VBA Skills?
-
Inside Windows Phone – Practical MVVM for Windows Phone
-
How to Make Your Open-Source Project Successful
-
Java Roots : Whats in a name : Reason behind naming of few great projects
-
Follow Up Post: Hiding All But The Current Bootstrap Popover
Add your comment
