#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. Falcons 26.3K posts
- 2. 49ers 45K posts
- 3. Game 7 48.9K posts
- 4. Penix 9,175 posts
- 5. #FTTB 7,255 posts
- 6. Giants 143K posts
- 7. Niners 6,079 posts
- 8. #LaGranjaVIP 87.6K posts
- 9. Zac Robinson 1,893 posts
- 10. Broncos 106K posts
- 11. Bijan 7,921 posts
- 12. #BaddiesAfricaReunion 12.6K posts
- 13. Happy Diwali 220K posts
- 14. Kittle 7,915 posts
- 15. Raheem 3,396 posts
- 16. Mac Jones 5,498 posts
- 17. Tyler 96.7K posts
- 18. Chase Lucas N/A
- 19. Elsie 5,579 posts
- 20. Daboll 12.2K posts