Creating index becomes extremely slow when all rows are in one partition

A customer reported that they found creating indexes sometimes become very slow in SQL2017. We analyzed this issue and found below symptom

This issue happens when creating index on partition table. But all rows are in one partition.
This issue happens… Continue reading Creating index becomes extremely slow when all rows are in one partition

Purchase Visio cloud subscriptions with your business domain

You and your team can now purchase Visio cloud subscriptions directly with your business domain. There’s no need to create a new account at onmicrosoft.com account or request a license through your IT department unless the self-service purchase is disa… Continue reading Purchase Visio cloud subscriptions with your business domain

Time Zone and Daylight Saving Support for Schedule Trigger

[Following material applies to Schedule Triggers in Azure Data Factory. Learn more about Schedule Trigger]
 
We are really excited to release Time Support for Schedule Trigger in Azure Data Factory. Going forward, you can create schedule triggers … Continue reading Time Zone and Daylight Saving Support for Schedule Trigger