#sqlcompression resultados de búsqueda
#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. Jets 113K posts
- 2. Sauce 79.6K posts
- 3. Colts 54.1K posts
- 4. Courtois 35.5K posts
- 5. Breece Hall 10.1K posts
- 6. Garrett Wilson 5,074 posts
- 7. Quinnen Williams 24K posts
- 8. $JFB N/A
- 9. Cheney 228K posts
- 10. Luis Diaz 25.8K posts
- 11. Liverpool 203K posts
- 12. AD Mitchell 6,293 posts
- 13. Bayern 108K posts
- 14. Beane 4,306 posts
- 15. Hakimi 24.2K posts
- 16. Veach 5,115 posts
- 17. Shaheed 16.4K posts
- 18. Mazi Smith 5,504 posts
- 19. Jerry 54.2K posts
- 20. Jermaine Johnson 3,207 posts