#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. Texas Tech 24.9K posts
- 2. Messi 115K posts
- 3. #SECChampionship 1,934 posts
- 4. #MLSCupFinal N/A
- 5. Inter Miami 17.8K posts
- 6. Big 12 2,708 posts
- 7. Slot 111K posts
- 8. #GoDawgs 6,291 posts
- 9. Harry Ford N/A
- 10. Illinois State 7,545 posts
- 11. Liverpool 114K posts
- 12. NDSU 1,082 posts
- 13. #iubb 1,020 posts
- 14. Ryan Williams N/A
- 15. Konate 27.1K posts
- 16. Purdue 9,989 posts
- 17. #WreckEm 4,291 posts
- 18. Vancouver 17.8K posts
- 19. Busquets 8,755 posts
- 20. Ben Roberts N/A