Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gregoryagu
Yak Posting Veteran
80 Posts |
 Posted - 2008-07-23 : 11:54:44
|
| I put an index on a column which is an SQL Variant, and got this message:Warning! The maximum key length is 900 bytes. The index 'IDX_val' has maximum length of 8016 bytes. For some combination of large values, the insert/update operation will fail.Is such an index an unwise affair? The table has only two columns, a uniqueidentifier and a SQL Variant.Greg |
|
|
gregoryagu
Yak Posting Veteran
80 Posts |
Posted - 2008-07-23 : 12:32:52
|
| The more I think about this, the more I think it is a bad idea; I don't know of any time the table would be searched by value, only by ID, so the index would never get used.Greg |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-23 : 14:08:27
|
| check this:http://www.sqlteam.com/article/the-sql_variant-datatype |
|
|
|
|
|
|
Indexing on an SQL Variant data type