Earlier I wrote a blog post about how Data Compression for Performance can help improve the efficiency of SQL Server. I often discuss this during my Comprehensive Database Performance Health Check as well.
If you do not have a CPU pressure issue, it is always a good idea to consider the option to compress your data for better performance. Many of my clients have implemented this to get an additional boost from their system.
Here is the video I have built on this topic.
You can get the script used in this video from this blog post: SQL SERVER – Script to Estimate Compression
Here are my few recent videos and I would like to know what is your feedback about them. Do not forget to subscribe SQL in Sixty Seconds series. I hope you appreciate learning about the last few SQL in Sixty Seconds Video.
- Detecting Memory Pressure – SQL in Sixty Seconds #186
- CPU Running 100% – SQL in Sixty Seconds #185
- Generate Script of SQL Server Objects – SQL in Sixty Seconds #184
- Prevent Unauthorized Index Modifications – SQL in Sixty Seconds #183
- MAX Columns Ever Existed in Table – SQL in Sixty Seconds #182
- Tuning Query Cost 100% – SQL in Sixty Seconds #181
- Queries Using Specific Index – SQL in Sixty Seconds #180
- Read Only Tables – Is it Possible? – SQL in Sixty Seconds #179
- One Scan for 3 Count Sum – SQL in Sixty Seconds #178
- SUM(1) vs COUNT(1) Performance Battle – SQL in Sixty Seconds #177
- COUNT(*) and COUNT(1): Performance Battle – SQL in Sixty Seconds #176
If you have any questions, you can always reach out to me on Twitter.
Reference:Â Pinal Dave (http://blog.SQLAuthority.com)
