Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Char(100) field VS Text
Message
From
19/04/2012 15:14:07
Michel Fournier
Level Extreme Inc.
Petit-Rocher, New Brunswick, Canada
 
 
To
19/04/2012 14:14:10
Fabio Lunardon
Lunacom
Marostica, Italy
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Re: Char(100) field VS Text
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01542085
Message ID:
01542163
Views:
27
>with 26 Miliion record with null value the better solution is
>VARCHAR(100) with Sparse attribute

Thanks for the info but I need the index as upcoming new records will have data on that field.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform