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

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

Webinar, November 17th: Keep employees connected and engaged in remote and blended work environments

Discover real world techniques that empower individuals and teams to stay connected using Microsoft 365.  Join this webinar on Tuesday, November 17 and learn how to make the most of current and coming features for highly collaborative wo… Continue reading Webinar, November 17th: Keep employees connected and engaged in remote and blended work environments

[ANNOUNCEMENT] Productivity for Humans Series: Meet Jerry Holy from the Special Olympics

We are thrilled to launch our third Humans of IT Productivity for Humans episode featuring Jerry Holy, a Data Specialist from the Special Olympics organization! Hear from Jerry about how he uses Microsoft 365 tools to stay productive, and why it’s impo… Continue reading [ANNOUNCEMENT] Productivity for Humans Series: Meet Jerry Holy from the Special Olympics