We have a table with half million records. There's a column which is storing xml data but the datatype of that column is varchar. This column alone is consuming 4097 bytes.
When i query the below table it is taking a long time to fetch the results (several hours) and i eventually cancel the query.
select <big column> from table (nolock)
Server memory is 32 GB, SQL memory is 22 GB, PLE is huge.
Any suggestions on how do i handle this situation? Thanks.