%3CLINGO-SUB%20id%3D%22lingo-sub-1594327%22%20slang%3D%22en-US%22%3EImprove%20Query%20Performance%20by%20Managing%20Statistics%20in%20Azure%20SQL%20%7C%20Data%20Exposed%3A%20MVP%20Edition%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1594327%22%20slang%3D%22en-US%22%3E%3CP%3E%3CFONT%20size%3D%223%22%3E%3CSPAN%3EWithin%20Azure%20SQL%20maintenance%20tasks%20such%20as%20backups%20and%20integrity%20checks%20are%20handled%20for%20you%2C%20and%20while%20you%20may%20be%20able%20to%20get%20away%20with%20automatic%20updates%20keeping%20your%20statistics%20up-to-date%2C%20sometimes%20it's%20not%20enough.%20Proactively%20managing%20statistics%20in%20Azure%20SQL%20requires%20some%20extra%20steps%2C%20and%20in%20this%20Data%20Exposed%20episode%20with%20MVP%20Erin%20Stellato%2C%20we'll%20step%20through%20how%20you%20can%20schedule%20and%20automate%20regular%20updates%20to%20statistics.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%225%22%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D2nSx9wuJKt4%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noreferrer%20noreferrer%20noreferrer%20noreferrer%20noreferrer%20noreferrer%20noreferrer%20noreferrer%20noreferrer%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EWatch%20on%20Data%20Exposed%3C%2FA%3E%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EAdditional%20Resources%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Folahallengren%2Fsql-server-maintenance-solution%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESQL%20Server%20Maintenance%20Solution%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fola.hallengren.com%2Fsql-server-index-and-statistics-maintenance.html%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESQL%20Server%20Index%20and%20Statistics%20Maintenance%3C%2FA%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EView%2Fshare%20our%20latest%20episodes%20on%26nbsp%3B-ERR%3AREF-NOT-FOUND-Channel%209%26nbsp%3Band%26nbsp%3B-ERR%3AREF-NOT-FOUND-YouTube!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1594327%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MSDataExposed.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F201130iE9AAF33173512AF8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22MSDataExposed.jpg%22%20alt%3D%22MSDataExposed.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EStatistics%20are%20critical%20to%20query%20performance.%20Learn%20how%20to%20manage%20statistics%20in%20Azure%20SQL%20with%20Erin%20Stellato.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1594327%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20SQL%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft

Within Azure SQL maintenance tasks such as backups and integrity checks are handled for you, and while you may be able to get away with automatic updates keeping your statistics up-to-date, sometimes it's not enough. Proactively managing statistics in Azure SQL requires some extra steps, and in this Data Exposed episode with MVP Erin Stellato, we'll step through how you can schedule and automate regular updates to statistics.

Watch on Data Exposed

 

Additional Resources:
SQL Server Maintenance Solution
SQL Server Index and Statistics Maintenance

 

View/share our latest episodes on Channel 9 and YouTube!