#sqlcompression Suchergebnisse
#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. #SNME 37.9K posts
- 2. Georgia 48.3K posts
- 3. Mason Thomas N/A
- 4. Drew 120K posts
- 5. Lagway 3,867 posts
- 6. Jade Cargill 15.8K posts
- 7. Game 7 148K posts
- 8. #UFCVegas110 9,267 posts
- 9. Underwood 2,777 posts
- 10. Jaire 9,768 posts
- 11. Rusev 2,891 posts
- 12. Forever Young 38.4K posts
- 13. Tiffany 23.1K posts
- 14. Nigeria 592K posts
- 15. Dawgs 7,741 posts
- 16. #AEWCollision 2,764 posts
- 17. Gators 6,326 posts
- 18. Salter N/A
- 19. Gunner Stockton 1,195 posts
- 20. Florida 77.3K posts