Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Towards the innovative SQL ideas
Browse by Tags · View All
sql server 124
sql 123
ms sql server 118
ms sql 117
database 108
tsql 80
#SQL Server 78
t-sql 74
#sql 71
sql server general 66

Archive · View All
April 2011 14
July 2011 12
May 2011 12
August 2011 11
June 2011 10
September 2011 8
December 2011 6
November 2011 6
September 2013 5
June 2013 5

SPARSE Column - New feature of SQL Server 2008

Apr 7 2011 12:00AM by Paresh Prajapati   

Recently during migration from SQL server 2005 to SQL Server 2008,  I have utilized one more feature of SQL server 2008 and that is SPARSE column. It is used to reduce storage data in tables, mostly when tables having 20-30 % NULL values.  It is really amazing feature and we can reduce storage space as we can with SPARSE.

Continue Reading...

Tags: sql, sql server 2008, sql server 2005, tsql, sql server, ms sql, ms sql server, t-sql, new features, enhancements,


Paresh Prajapati
6 · 23% · 7533
1
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

1  Comments  

  • OK, I'll admit. I had no idea if you put a number after "GO" it would do that command x number of times. Thanks for these little tidbits of info.

    commented on May 4 2011 5:15PM
    Amy
    498 · 0% · 77

Your Comment


Sign Up or Login to post a comment.

"SPARSE Column - New feature of SQL Server 2008" rated 5 out of 5 by 1 readers
SPARSE Column - New feature of SQL Server 2008 , 5.0 out of 5 based on 1 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]