#sqlcompression hasil pencarian
#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. Dolphins 25.5K posts
- 2. Lamar 41.3K posts
- 3. Ravens 38.5K posts
- 4. Ryan Rollins 2,177 posts
- 5. Mike McDaniel 1,902 posts
- 6. Derrick Henry 4,313 posts
- 7. Achane 3,593 posts
- 8. Jackson 5 3,197 posts
- 9. #TNFonPrime 2,061 posts
- 10. Happy Halloween 505K posts
- 11. Ollie Gordon 2,000 posts
- 12. Mark Andrews 2,744 posts
- 13. #911onABC 13.7K posts
- 14. Tulane 8,439 posts
- 15. Kyle Hamilton 1,395 posts
- 16. #PhinsUp 3,725 posts
- 17. Georgetown 3,566 posts
- 18. Bateman 3,838 posts
- 19. Dahlin N/A
- 20. UTSA 2,635 posts