#sqlcompression search results
#sqltip #sqlcompression --sp_estimate_data_compression_savings --@ schema_name -- ,@ object_name -- ,@ index_id -- ,@ partition_number -- ,@ data_compression SET @ SQL = ' EXEC sp_estimate_data_compression_savings ''' +@ Schema + ''',''' +@ Table + ''',NULL,NULL,''ROW'';'
#sqltip #sqlcompression #sqlindex DROP INDEX IF EXISTS sch1.tab1.IX1 CREATE NONCLUSTERED INDEX IX1 ON sch1.tab1 (col1 ASC) INCLUDE (col2) WITH ( DROP_EXISTING = ON , DATA_COMPRESSION = ROW ) ;
To check if a db backup is compressed use RESTORE HEADERONLY. If Compressed =1, it is #SQLcompression
#sqltip #sqlcompression --sp_estimate_data_compression_savings --@ schema_name -- ,@ object_name -- ,@ index_id -- ,@ partition_number -- ,@ data_compression SET @ SQL = ' EXEC sp_estimate_data_compression_savings ''' +@ Schema + ''',''' +@ Table + ''',NULL,NULL,''ROW'';'
To check if a db backup is compressed use RESTORE HEADERONLY. If Compressed =1, it is #SQLcompression
Something went wrong.
Something went wrong.
United States Trends
- 1. Ohtani 64K posts
- 2. #WorldSeries 67.7K posts
- 3. Chiefs 76.1K posts
- 4. #WWERaw 42.8K posts
- 5. Mahomes 23.6K posts
- 6. Mariota 7,533 posts
- 7. #Dodgers 12.2K posts
- 8. Treinen 2,830 posts
- 9. Terry 23.5K posts
- 10. Kelce 15.6K posts
- 11. Rashee Rice 3,723 posts
- 12. #RaiseHail 7,093 posts
- 13. Maxey 9,145 posts
- 14. Roki 5,312 posts
- 15. Mookie 7,903 posts
- 16. Glasnow 5,389 posts
- 17. Vladdy 5,103 posts
- 18. Deebo 5,573 posts
- 19. Dave Roberts 3,090 posts
- 20. Commanders 33.8K posts