tag:blogger.com,1999:blog-6538321000057298497.post2383960286889314841..comments2023-05-20T03:26:37.996-07:00Comments on SQL Server tips ,SQL Server tutorials, database tips- Indiandotnet: Do you know Compress & Decompress function in SQL SERVER 2016 ?Anonymoushttp://www.blogger.com/profile/10272758489608834274noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-6538321000057298497.post-75285704836106148582016-10-21T20:53:27.554-07:002016-10-21T20:53:27.554-07:00Shyam, It might be if you just think of typecastin...Shyam, It might be if you just think of typecasting but if think about the broader picture like earlier you were sending pure 1 GB data to network channel but now with this compress you might send 500 MB.So, it might be overall benefit. But you are correct, surely I will come up with an example and more detail.Anonymoushttps://www.blogger.com/profile/10272758489608834274noreply@blogger.comtag:blogger.com,1999:blog-6538321000057298497.post-81491479649815854392016-10-19T21:16:51.159-07:002016-10-19T21:16:51.159-07:00Don't you think, this typecasting again a bott...Don't you think, this typecasting again a bottleneck for performance?shyamhttps://www.blogger.com/profile/09346726406685090882noreply@blogger.com