SQL Server 2008 : Store 100K char string with indexing option
Hi,
How can I store a char string upto 100K within a column? I could use text else ntext but will normal indexing work with it?
Thanks
How can I store a char string upto 100K within a column? I could use text else ntext but will normal indexing work with it?
Thanks
Last Comment
ASKER
Hi Razmus,
Do you have any example on full text indexes on such column which may contain upto 100K char data?
What are the pros and cons of this method?
Is this the only way?
Thanks
Do you have any example on full text indexes on such column which may contain upto 100K char data?
What are the pros and cons of this method?
Is this the only way?
Thanks
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks for the details.
Are you asking for online examples to get started;
-- Yeap
Are you asking for online examples to get started;
-- Yeap
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft SQL Server 2005
Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.
72K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
I don't believe you can use a standard index on [n]varchar(max), but you CAN use Full Text Indexes.