#sqlcompression search results
#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. White House 112K posts
- 2. Good Tuesday 30.9K posts
- 3. Talus Labs 16K posts
- 4. Rick Scott 1,189 posts
- 5. NBA IS BACK 15.6K posts
- 6. #3YearsOfMidnights N/A
- 7. Cobie 43.2K posts
- 8. #tuesdayvibe 1,970 posts
- 9. Taco Tuesday 10.7K posts
- 10. Cuomo 73.7K posts
- 11. #ThunderUp N/A
- 12. East Wing 88.2K posts
- 13. Sanae Takaichi 90.8K posts
- 14. Gucci 28.4K posts
- 15. #TuesdayThoughts N/A
- 16. Happy NBA 5,578 posts
- 17. Joe Carter 3,545 posts
- 18. #TuesdayMotivation N/A
- 19. Curtis 42.9K posts
- 20. $BYND 128K posts