#sqlcompression risultati di ricerca
#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. Happy Halloween 1.1M posts
- 2. #RUNSEOKJIN_epTOUR_ENCORE 176K posts
- 3. THE TRUTH UNTOLD 13.6K posts
- 4. YouTube TV 56.3K posts
- 5. Good Friday 33.3K posts
- 6. #Jin_TOUR_ENCORE 162K posts
- 7. #FridayVibes 2,718 posts
- 8. Reformation Day 1,015 posts
- 9. Mary Ann 1,091 posts
- 10. Hulu 18.6K posts
- 11. #PondPhuwinFanconD1 834K posts
- 12. Trick or Treat 288K posts
- 13. #T1WIN 10.3K posts
- 14. YTTV N/A
- 15. Fubo 1,418 posts
- 16. Ryan Rollins 13.4K posts
- 17. Mindy 3,916 posts
- 18. Mork 1,989 posts
- 19. Mr Ed 2,893 posts
- 20. Mike McDaniel 5,598 posts