Tag : data compression - SentryOne Team Blog

Tag: data compression

I'm Speaking at SQL Saturday Edmonton #SQLSat594

I'm Speaking at SQL Saturday Edmonton #SQLSat594

Melissa Connors (@MelikaNoKaOi) discusses her upcoming trip to speak at SQL Saturday Edmonton and provides links to Data Compression posts and slides.

Visualizing Data Compression: See it for Yourself

Visualizing Data Compression: See it for Yourself

Melissa Connors (@MelikaNoKaOi) explains how visualizing data compression (through DBCC PAGE) helps you better understand SQL Server compression methods.

Erin Stellato : Compression and its Effects on Performance

Erin Stellato : Compression and its Effects on Performance

Erin Stellato (@erinstellato) takes a look at the new COMPRESS and DECOMPRESS functions, comparing their impact on space and performance to traditional data compression.

Photo credit: rsdio

#EntryLevel : Compression & Data Types

Melissa Connors (@MelikaNoKaOi) walks through the basics of when SQL Server data will benefit from compression and illustrates cases when it will not.

How to Reduce Latency and Boost SQL Server Performance Webcast, Slides, and Scripts

Kevin Kline (@kekline) shares the slide deck and video from his recent webinar on reducing latency and boosting performance in SQL Server.

Applying Data Compression to the SQL Sentry Database : Part 5 (Follow-up)

Melissa Connors (@MelikaNoKaOi) follows up on her data compression series, providing details on wait statistics, MAXDOP settings, and Performance Advisor.

Applying Data Compression to the SQL Sentry Database : Part 4

Melissa Connors (@MelikaNoKaOi) concludes her data compression series, providing the DDL commands you can apply to your own SQL Sentry database.

Applying Data Compression to the SQL Sentry Database : Part 3

Melissa Connors (@MelikaNoKaOi) continues her compression series, looking at disk I/O, memory usage, and decision-making tables for selecting compression.

Applying Data Compression to the SQL Sentry Database : Part 2

Melissa Connors (@MelikaNoKaOi) continues her series on data compression, focusing on costs of implementation, index maintenance, and running SQL Sentry.

Applying Data Compression to the SQL Sentry Database : Part 1

Melissa Connors (@MelikaNoKaOi) investigates the approach, costs, and space/performance benefits of applying data compression to the SQL Sentry database.