Manage Compression Bug In SSMS

Arun Sirpal found a bug in Management Studio 2016:

The actual message that you are presented states: Tables with sparse columns cannot be compressed – I have no sparse columns.

I never had this issue with SQL Server 2014 Management Studio

It looks like that bug has been fixed in the latest version of Management Studio, so if that affects you, it’s worth an upgrade.

Related Posts

Victimless Deadlocks And SSMS

Michael J. Swart shows a scenario where the deadlock graph fails to open in SQL Server Management Studio: I recently got this error in Management Studio when trying to view a deadlock graph that was collected with an extended events session: Failed to initialize deadlock control. Key cannot be null. Parameter name: key I found […]

Read More

Full-Screen SSMS

Wayne Sheffield has another SSMS tip for us: Do you ever find yourself working on a query and realize that you need just a bit more real estate in the SSMS window? Or perhaps you find that all the toolbars, menus, etc. are cluttering things up? To solve these issues, you can toggle the full […]

Read More


October 2016
« Sep Nov »