When trying to extract data from a text or image field, it is not always clear, how many bytes of data can be expected. Here’s a way how to determine this:
1> SET textsize 1669842
2> go
1> SELECT Xml FROM TradeXml WHERE AsOfDate = ‘20091019′ AND TradeId = ‘xxxxxxx’
2> go
In order to determine the value that needs [...]
Log on to the server
$ devinfo -i /dev/md/rdsk/d301
/dev/md/rdsk/d301 0 0 16384 512 1