#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'';'
#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. Clippers 14K posts
- 2. Harden 10.2K posts
- 3. Huda 8,765 posts
- 4. Ty Lue 1,497 posts
- 5. #DWTS 50K posts
- 6. Kawhi 3,648 posts
- 7. Giannis 30K posts
- 8. #RHOSLC 7,702 posts
- 9. Whitney 15.7K posts
- 10. #APEC2025 74.3K posts
- 11. #RMxAPEC 184K posts
- 12. #DearOlandria 1,109 posts
- 13. Askarov N/A
- 14. South Korea 72.7K posts
- 15. Markstrom 1,723 posts
- 16. Caden 8,437 posts
- 17. Chris Paul 1,558 posts
- 18. Zubac 1,696 posts
- 19. Wayne 56.6K posts
- 20. Manola 5,693 posts