Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
what are called as sparse columns?
September 28, 2010
Please explain with an example or get me alink which has a good explanation.
Posted Date: September 29, 2010 Points: 5
Sparse columns are ordinary columns that have an optimized storage for null values.
The storage space is optimized for null values and processing time increased for nonnull values.
CREATE TABLE DocumentStore
(DocID int PRIMARY KEY,
Title varchar(200) NOT NULL,
ProductionSpecification varchar(20) SPARSE NULL,
ProductionLocation smallint SPARSE NULL,
MarketingSurveyGroup varchar(20) SPARSE NULL ) ;
MSDN Link: http://msdn.microsoft.com/en-us/library/cc280604.aspx
To post reply
Related Questions Related Questions
How to merge or group the columns in gridview....??
Calculation in DataGridView Columns
Need a Function to be called from a custom validator to check the number of characters in a textbox
auotgenerate columns-windows application
GridView dynamic rows and columns on user input
In new form page of a list 2 lookup columns cascade in Sharepoint
How to count total no. of columns in a table
How to get the row in an sql server with out defining columns in where condition?
Freezing Both Header and First 2 Columns of a Repeater
Latest Forum Questions From The Same Category
Help to get SQL output
how to restore my sql database from my hosting provider?
SQL query to update date range
Add allowance to employee table is wrong or true according to my case
how to remove trailing zeroes in a decimal in sql server
Required Union All Result in two different column
Sql Multiple table data retrival
Table Translation records
How select huge Data from sql without take long time?
Passing using parameter in store procedure get the top3 record from the table
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend