August 24, 2011 at 9:23 am
Hi, I get this warning when I created the table
Warning! The maximum key length is 900 bytes. The index 'FBK_Comp_iu' has maximum length of 4004 bytes. For some combination of large values, the insert/update operation will fail.
How can I fix it?
Thank you
August 24, 2011 at 9:55 am
You're trying to build an index off of a field or fields that is too large. You have to use less or smaller fields to build the index. There is a limit on size.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 24, 2011 at 11:32 am
Post your table definition, including the index create statements.
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply