?
Solved

query and display compressed data?

Posted on 2012-04-01
3
Medium Priority
?
286 Views
Last Modified: 2012-04-05
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?

for instance,

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)
0
Comment
Question by:jimwarrenus
3 Comments
 
LVL 25

Assisted Solution

by:jogos
jogos earned 750 total points
ID: 37793738
Is it compressed by SQL Server?

Can you post the table definition.
0
 
LVL 16

Accepted Solution

by:
Deepak Chauhan earned 750 total points
ID: 37793801
Hi Dear...

            please check select permission on this table it may be possible u dont have permission on 'otherdata column of this table.
                I don't think data compression is the reason of doesn't showing 'otherdata' column as i understand data compression can be two type row level or page level if two column is showing from this table which is also part of complete row and if we are talking about page level then page is also stored data in row format.

you can test this with (select * from order) if you dont have full select permission then query will through an error....
0
 

Author Closing Comment

by:jimwarrenus
ID: 37812982
i finally heard from the developer and turns out they also refer to it as "packed"....<br />this solved the problem:<br /><br />SELECT CAST(CAST(SUBSTRING(BIGDAT<wbr />A,1,4)AS VARBINARY) AS BIGINT)<br />FROM PROCESSING
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based developeā€¦
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recovā€¦
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

590 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question