i have a table in a sql server 2008 server that has compressed data in several columns
how do i query and view/display that data?
select orderno, shipdate, otherdata from orders
where shipdate > '20111231'
the orderno and shipdate are not compressed and display fine..... the data in the otherdata column is compressed and either doesnt display at all (mgmt studio), or displays 'junk' characters (in some other query tools)