Data Compression for Performance - SQL in Sixty Seconds 188

[@elvishfiend]

We had a massive speed improvement when we compressed our Vendor DB - using Page Compression, we compressed it to about 25%. The tables were very wide and had mostly null values, which definitely helped. Helps with both amount of data we can store in RAM and effective Disk Throughput which can get costly when running in the cloud.

[@PinalDaveSQLAuthority]

Excellent to hear that.

[@thiagosa84]

Thanks once more Pinal. Great content

[@PinalDaveSQLAuthority]

More to come!

[@VimalPatel-ek8pb]

Thanks Pinal for very informative details for compressed data in sql in sixty seconds....hope we will sure to get such wonderful details from you....

[@PinalDaveSQLAuthority]

You are most welcome

[@frankzelazko]

Thank you Pinal for yet another very useful video

[@PinalDaveSQLAuthority]

Thank you

[@kennethgardzinski]

Good information as usual. You should try 'dark mode' in SSMS; it's better for your eyes.

[@PinalDaveSQLAuthority]

Very true.

[@koushikdey100]

Hi Pinal, can you please helps me to understand what steps should a dev follow to optimize a slow running queries. Any videos from your tutorial can be a great help.

[@PinalDaveSQLAuthority]

There are many video on this channel.

[@kotekr4383]

hi sir its amazing .... and here doubt is roll back is the same below command will work for both row and page level compression.
ALTER TABLE Production.WorkOrder REBUILD PARTITION = ALL
WITH (DATA_COMPRESSION = NONE);
GO

[@PinalDaveSQLAuthority]

It should.

[@kotasuresh7990]

Hi Pinal,
When I ran CTE the query getting suspended
Can you please help me what causing this issue
🙏

[@PinalDaveSQLAuthority]

Without more info, I can't do it.

[@murugana4661]

Store procedures plz

[@PinalDaveSQLAuthority]

In the description box.