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
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site