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

Availability Group Latency Reports

Sourabh Agarwal points out some new reports in Management Studio 17.4: The Latency data collection functionality and the associated reports allows a database administrator to quickly discern the bottleneck in the log transport flow between the Primary and the Secondary replicas of an Availability Group. This feature does NOT answer the question “Is there latency […]

Read More

Vertical Selection In SSMS

Bert Wagner shows off vertical selection in SSMS (using the Alt key): Sometimes when writing an ad hoc query you might want to take the results of one query and put them into an IN() statement of another query. Sure, you can write a subquery to put into your IN() statement…but that’s too much work […]

Read More

Categories

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