Category: Data Compression

Melissa Connors posts her slides and recorded presentation from a SentryOne sponsored meeting of the #PASSWIT Virtual Chapter.
Melissa Connors explains how visualizing data compression (through DBCC PAGE) helps you better understand SQL Server compression methods.
Erin Stellato takes a look at the new COMPRESS and DECOMPRESS functions, comparing their impact on space and performance to traditional data compression.
Melissa Connors (@MelikaNoKaOi) follows up on her data compression series, providing details on wait statistics, MAXDOP settings, and Performance Advisor.
Melissa Connors (@MelikaNoKaOi) concludes her data compression series, providing the DDL commands you can apply to your own SQL Sentry database.
Melissa Connors continues her compression series, looking at disk I/O, memory usage, and decision-making tables for selecting compression.
Melissa Connors continues her series on data compression, focusing on costs of implementation, index maintenance, and running SQL Sentry.
Melissa Connors investigates the approach, costs, and space/performance benefits of applying data compression to the SQL Sentry database.

Top Categories

See all

Get the best SQL query analysis and optimization tool – free!

Plan-Explorer-logo-RGB-800px
  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More