#sqlcompression resultados da pesquisa
#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. Cheney 135K posts
- 2. Election Day 128K posts
- 3. Jakobi Meyers 4,397 posts
- 4. #csm219 3,543 posts
- 5. Mamdani 567K posts
- 6. Logan Wilson 8,413 posts
- 7. Shota 17.4K posts
- 8. Cuomo 278K posts
- 9. New Jersey 203K posts
- 10. Iraq 55.6K posts
- 11. GO VOTE 99.2K posts
- 12. #TheView N/A
- 13. #Election2025 3,100 posts
- 14. Rickey 1,866 posts
- 15. #tuesdayvibe 2,648 posts
- 16. New Yorkers 83.3K posts
- 17. New York City 171K posts
- 18. Waddle 6,059 posts
- 19. GOOD MORNING MINTO N/A
- 20. Rolex 17.7K posts