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)
It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers.
According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…