Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 Question

Author  Topic 

Narmadha
Starting Member

1 Post

Posted - 2014-12-16 : 17:30:17
i have a doubt how to write a query which finds non compressed index and table in a database and compresses it. Also how to do it for all databases at once (like loop one database after the other)..

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2014-12-17 : 01:37:29
see if this helps
http://stackoverflow.com/questions/16988326/query-all-table-data-and-index-compression

Javeed Ahmed
https://www.linkedin.com/pub/javeed-ahmed/25/5b/95
Go to Top of Page
   

- Advertisement -