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)
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.