PostList

MS SQL COMPRESS AND DECOMPRESS

MS SQL COMPRESS AND DECOMPRESS

MS SQL COMPRESS and DECOMPRESS are introduced into MS SQL version 2016. In this post we will read the overview of both functions, limitations and benefits. We will also test the performance compared to ROW and PAGE compression methods....

Read More
MS SQL STRING_SPLIT

MS SQL STRING_SPLIT

Let's talk about MS SQL STRING_SPLIT table-valued function introduced in MS SQL version 2016 for splitting string values by a separator. How we did it before and test its performance compared to the old way. We will also see the pros but also cons of the function....

Read More
MS SQL STRING_AGG

MS SQL STRING_AGG

In this post we will learn something about MS SQL STRING_AGG function introduced in MS SQL version 2017 for string aggregation, how we did it before and test its performance compared to the old way....

Read More