Updating Stats in Azure SQL Database

Recently we were having some issues with DTU utilization in Microsoft SQL Azure. One of the troubleshooting steps that was suggested was the update statistics and rebuild indexes. This is already being done and didn’t really solve the issue because we noticed that even after we stopped updating and rebuilding statistics everything was working fine….

Profile columns for indexes

Every once in a while, as part of a consulting project I need to investigate all the different columns and datatypes used within the tables. Often in order to achieve this I would write the SQL script individually but since I’ve been doing it regularly recently I’ve decided to automate the script. The blue script…