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 |
|
Shiva808
Starting Member
6 Posts |
 Posted - 2007-01-22 : 23:00:04
|
| Hi,We have a large database table with an IMAGE field holding documents of < 1MB size.Over time this table has become quite large and operations on it have become slow.My question is, would changing from IMAGE to varbinary(max) make the binary storage more efficient thereby making the table operations faster.Also, would the table size be smaller with varbinary(max)?Thanks |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-01-22 : 23:20:49
|
you can remove the thread if you posted wrongly to the wrong forum. Anyway varbinary(max) should not be under SQL 2000 but 2005
KH |
 |
|
|
|
|
|
varbinary(max)