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

Formatting with RegEx in SQL Server

Shane O’Neill has a problem: This is a contrived example but I was given a script that got the “Discipline”, “DocumentVersion”, “DocumentNumber”, “SectionNumber”, and “SectionName” out of the above. And while it works, I hate that formatting. Everything is all squashed and shoved together. No, thanks. Let’s see if we can make this more presentable. […]

Read More

The Value Of Central Management Server

Jeff Iannucci explains the benefits of Central Management Servers: If you have more than a handful of instances, you really owe it to yourself to take a few minutes and set up your own CMS. The hard part is getting a list of all the instances, but you need to do that anyways, right? Once […]

Read More

Categories

October 2016
MTWTFSS
« Sep Nov »
 12
3456789
10111213141516
17181920212223
24252627282930
31