#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. Broncos 41.7K posts
- 2. Colts 27.2K posts
- 3. Giants 56.9K posts
- 4. Packers 28.2K posts
- 5. Cowboys 25.2K posts
- 6. Chargers 27.5K posts
- 7. Lattimore 4,194 posts
- 8. Sean Payton 4,289 posts
- 9. Bo Nix 4,486 posts
- 10. Nate Hobbs 1,238 posts
- 11. Pickens 9,851 posts
- 12. #RaiseHail 5,638 posts
- 13. Herbert 12K posts
- 14. Jalen 36.7K posts
- 15. Jonathan Taylor 3,806 posts
- 16. Raiders 67.5K posts
- 17. Brandon Aubrey 2,360 posts
- 18. Jayden 13.4K posts
- 19. Mariota 1,176 posts
- 20. Joe Whitt 1,518 posts