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 |
|
kkr12
Starting Member
12 Posts |
 Posted - 2006-02-22 : 15:28:36
|
| Hi, I've a table with a primary key column of VARCHAR field. The JBOSS app server is throwing some deadlocks while using this table and so we got a reccomendation from JBOSS to add a new column of INT type and make it the primary key column instead of VARCHAR field as VARCHAR field as primary key in SQLserver is very bad. Is this really true ? Can someone point me to any documentation/articles which says the primary key column in SQLserver should not be VARCHAR field ?Thanks,kkr |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
VARCHAR field as primary key column