Alan! How about a little test data? This isn't difficult but it's impossible to solve in a reasonable fashion without a copy of your field table and a...

Two things... first, post the code that you've tried. Second, if you want a better answer quicker, please see the link in my signature line below. 😉

Just add the "IGNORE DUPES" option to the Primary Key constraint.

Sorry, Gift Peddie... Wasn't directed at you or I'd have used your post as a quote. No... I've heard this myth about using powers of 2 for varchar lengths...

Stuff like that shouldn't be hardcoded. It should be in a configuration table.

Why do you think your indexes are "all doing good"?...

For a better, tested answer quicker. please see the link in my signature below.

The rowcounts in the SysIndexes table may not be anywhere near accurate until you run DBCC UPDATEUSAGE.

BWAA-HAAA! Don't you guys know "vapor-ware" when you see it? It's obviously a "future release". :D:P:hehe:

Dynamic SQL to run a cursor... how slow do you actually want things to run?

I agree with what the others have already stated... it would be fair better to state...

If you simply behead the first two people that make that mistake, I guarantee the others will be much more careful. 😛

Ok then... anyone anywhere got any consistant demonstrable code of any type that shows any consistant performance increase using any power-of-2 length for any Varchar sitiuation in any table? ...

Heh... why does everyone blame dynamic SQL... that's not what makes these drop downs painfully slow. Poor intial design, lack of proper indexes, and non-sargable SQL is what makes...

Thanks Ron :blush:

Start here...

http://www.sqlcourse.com/

... then move to Books Online which comes free with SQL Server... concentrate on the "Contents" tab.

SQL Server is a big subject... don't try to learn it all at...