Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Indexing Expand / Collapse
Author
Message
Posted Monday, February 22, 2010 12:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 7, 2013 5:39 AM
Points: 2, Visits: 4
Can i know how many nvarchar(max) column can add in one index?. Its very urgent situation.
please replay to this mail id : vino.kumar587@gmail.com

Thanks
Vinoth Kumar.T
Contact No : +91-9488667612
Post #870103
Posted Monday, February 22, 2010 12:40 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, February 19, 2013 2:02 AM
Points: 846, Visits: 303
Check BOL.

Regards,

Willem
http://wschampheleer.wordpress.com
Post #870108
Posted Monday, February 22, 2010 5:38 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 29, 2010 5:23 AM
Points: 194, Visits: 2,357
You can't have an mvarchar(max) as a key column (a searchable column) in an index. Only as an included column
Post #870260
Posted Monday, February 22, 2010 7:54 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 6:23 AM
Points: 9,928, Visits: 11,196
vino.kumar587 (2/22/2010)
Can i know how many nvarchar(max) column can add in one index?. Its very urgent situation.

Can I ask why you are wondering, and why it is so urgent? It seems like an odd question...

Paul




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #870366
Posted Monday, February 22, 2010 8:32 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 29, 2010 5:23 AM
Points: 194, Visits: 2,357
Paul White (2/22/2010)
vino.kumar587 (2/22/2010)
Can i know how many nvarchar(max) column can add in one index?. Its very urgent situation.

Can I ask why you are wondering, and why it is so urgent? It seems like an odd question...

Paul


anyone prepared to bet against something along the lines of "The developers ... every text field is nvarchar(max) ... performance terrible ... I've been asked to tune ... "
Post #870397
Posted Monday, February 22, 2010 8:37 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 6:23 AM
Points: 9,928, Visits: 11,196
Andrew Gothard-467944 (2/22/2010)
anyone prepared to bet against something along the lines of "The developers ... every text field is nvarchar(max) ... performance terrible ... I've been asked to tune ... "

Not me




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #870404
Posted Monday, February 22, 2010 8:39 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Monday, November 17, 2014 12:50 PM
Points: 13,872, Visits: 9,598
You can include any number of them in an index. You can't have them as the key columns for the index. It's really as simple as that.

Often, you're better off using a full text index on that kind of column, instead of a regular index.

What problem are you trying to solve by indexing these?


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #870409
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse