I was asked to increase the size of a column in a table from it's current value of 900 bytes to around 2000. Forgetting why I set the value to 900 originally, I found I was unable to create an index over 900 bytes (the table contains regular expressions for those wondering why I am attempting to index a column this big).
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da_0ldf.asp
I can't find a workaround to enforce uniqueness on the table - not sure why this limit is in place. It doesn't appear to have changed for 2005
http://msdn.microsoft.com/SQL/2005/2005Webcasts/TSQLQandA.aspx
although there is a new feature called "included columns in indexes" which would solve problems in some cases but not in mine
Theme design by Jelle Druyts
Pick a theme: BlogXP calmBlue Candid Blue dasBlog Discreet Blog Blue Elegante essence Just Html MadsSimple Mobile Mono Movable Radio Blue Movable Radio Heat nautica022 orangeCream Portal Project84 Project84Grass Slate Sound Waves Tricoleur useit.com Voidclass2
Powered by: newtelligence dasBlog 1.9.6264.0
The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.
© Copyright 2010, Noel Watson Consulting Ltd.
E-mail