{"id":111998,"date":"2026-07-23T08:21:41","date_gmt":"2026-07-23T08:21:41","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/?post_type=podcast&#038;p=111998"},"modified":"2026-07-23T08:21:42","modified_gmt":"2026-07-23T08:21:42","slug":"the-art-of-sql-server-query-tuning-and-execution-plans-with-hugo-kornelis","status":"publish","type":"podcast","link":"https:\/\/www.red-gate.com\/simple-talk\/podcasts\/the-art-of-sql-server-query-tuning-and-execution-plans-with-hugo-kornelis\/","title":{"rendered":"The art of SQL Server query tuning and execution plans &#8211; with Hugo Kornelis"},"content":{"rendered":"\n<div class=\"mb-2xl\">\n            <button data-youtube-url=\"https:\/\/www.youtube.com\/embed\/By3N-JmZxCA?si=zvnaGcYdeni-mKR8\" id=\"podcastModalButton\" class=\"relative aspect-[16\/9] bg-gray-900 flex items-center justify-center flex-col gap-md w-full p-md\">\n                            <img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2026\/07\/HugoKornelisSTPodcastBackground-1024x576.png\" class=\"object-cover absolute inset-0 w-full h-full wp-post-image\" alt=\"\" srcset=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2026\/07\/HugoKornelisSTPodcastBackground-1024x576.png 1024w, https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2026\/07\/HugoKornelisSTPodcastBackground-300x169.png 300w, https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2026\/07\/HugoKornelisSTPodcastBackground-768x432.png 768w, https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2026\/07\/HugoKornelisSTPodcastBackground.png 1280w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/>                        <svg class=\"w-12 h-auto absolute m-auto text-base-white\" width=\"20\" height=\"20\" viewBox=\"0 0 20 20\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n                <path d=\"M10 0C3.5 0 0 3.5 0 10C0 16.5 3.5 20 10 20C16.5 20 20 16.5 20 10C20 3.5 16.5 0 10 0ZM11.47 12.71C10.08 13.51 8.64 14.11 7.25 14.5C7.06 13.13 6.95 11.61 6.95 10C6.95 8.39 7.06 6.87 7.25 5.5C8.64 5.89 10.08 6.49 11.47 7.29C12.86 8.09 14.06 9.02 15.05 10C14.07 10.98 12.87 11.9 11.47 12.71Z\" fill=\"currentColor\" \/>\n            <\/svg>\n\n        <\/button>\n    \n    <dialog id=\"podcastModal\" class=\"\">\n        <div class=\"bg-base-black bg-opacity-80 fixed inset-0 z-10 h-full w-full max-w-full max-h-full flex items-center justify-center\">\n            <div class=\"mx-auto relative w-full container\">\n                <div class=\"flex overflow-hidden rounded-xs bg-base-black\">\n                    <div class=\"relative aspect-[16\/9] w-full\">\n                        <iframe loading=\"lazy\" id=\"podcastYoutubeVideo\" class=\"absolute inset-0 w-full h-full\" width=\"560\" height=\"315\" src=\"\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n                    <\/div>\n                <\/div>\n                <button id=\"closeModalButton\" class=\"absolute -top-12 -right-0 w-auto h-12 flex items-center justify-center\">\n                    <svg class=\"w-8 h-8\" width=\"20\" height=\"20\" viewBox=\"0 0 20 20\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n                        <path d=\"M10 0C3.5 0 0 3.5 0 10C0 16.5 3.5 20 10 20C16.5 20 20 16.5 20 10C20 3.5 16.5 0 10 0ZM13.37 11.95C13.89 12.47 14.4 12.98 14.91 13.65C14.77 13.88 14.59 14.11 14.38 14.32C14.16 14.54 13.9 14.75 13.65 14.91C13.06 14.43 12.51 13.91 11.96 13.36L10.01 11.41L8.06 13.36C7.54 13.88 7.03 14.39 6.36 14.9C6.13 14.76 5.9 14.58 5.69 14.37C5.47 14.15 5.26 13.89 5.1 13.64C5.58 13.05 6.1 12.5 6.65 11.95L8.6 10L6.65 8.05C6.13 7.53 5.62 7.02 5.11 6.35C5.25 6.12 5.43 5.89 5.64 5.68C5.86 5.46 6.12 5.25 6.37 5.09C6.96 5.57 7.51 6.09 8.06 6.64L10.01 8.59L11.96 6.64C12.48 6.12 12.99 5.61 13.66 5.1C13.89 5.24 14.12 5.42 14.33 5.63C14.55 5.85 14.76 6.11 14.92 6.36C14.44 6.95 13.92 7.5 13.37 8.05L11.42 10L13.37 11.95Z\" fill=\"white\" \/>\n                    <\/svg>\n                <\/button>\n            <\/div>\n        <\/div>\n    <\/dialog>\n    \n            <div class=\"flex flex-wrap gap-4 items-center mt-3xl\">\n            <p class=\"mb-0 leading-tight font-bold\">Listen on:<\/p>\n            <div class=\"flex flex-wrap gap-xl\">\n                                    <a class=\"duration-200 hover:opacity-70\" href=\"https:\/\/open.spotify.com\/episode\/4XVIYroWODyQ3Diia0WzLn\" target=\"_blank\">\n                        <img decoding=\"async\" class=\"h-10 w-auto max-w-full\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/themes\/simple-talk-theme-2024\/assets\/images\/sharing\/spotify-podcast.png?v=2\" alt=\"Listen on Spotify\">\n                    <\/a>\n                                                    <a class=\"duration-200 hover:opacity-70\" href=\"https:\/\/podcasts.apple.com\/us\/podcast\/the-art-of-sql-server-query-tuning-and-execution\/id1773262159?i=1000777999128\" target=\"_blank\">\n                        <img decoding=\"async\" class=\"h-10 w-auto max-w-full\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/themes\/simple-talk-theme-2024\/assets\/images\/sharing\/apple-podcast.png?v=2\" alt=\"Listen on Apple Podcasts\">\n                    <\/a>\n                                                    <a class=\"duration-200 hover:opacity-70\" href=\"https:\/\/sites.libsyn.com\/537157\/the-art-of-sql-server-query-tuning-and-execution-plans-with-hugo-kornelis\" target=\"_blank\">\n                        <img decoding=\"async\" class=\"h-10 w-auto max-w-full\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/themes\/simple-talk-theme-2024\/assets\/images\/sharing\/libsyn-podcast.png?v=2\" alt=\"Listen on Libsyn\">\n                    <\/a>\n                                                    <a class=\"duration-200 hover:opacity-70 flex-shrink-0\" href=\"https:\/\/music.amazon.com\/podcasts\/bb23354a-9850-428f-9cb3-83235ef279c6\/episodes\/f6b85724-1ed0-4578-85bd-cfd51be0b9cf\/simple-talks-the-art-of-sql-server-query-tuning-and-execution-plans-with-hugo-kornelis\" target=\"_blank\">\n                        <img decoding=\"async\" class=\"h-10 w-auto max-w-full\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/themes\/simple-talk-theme-2024\/assets\/images\/sharing\/amazon-podcast.png?v=2\" alt=\"Listen on Amazon Music\">\n                    <\/a>\n                            <\/div>\n        <\/div>\n    \n    <\/div>\n\n\n<p><strong>Grant Fritchey<\/strong> is joined by SQL Server veteran and long-time Microsoft MVP,\u00a0<strong>Hugo Kornelis<\/strong>, to talk all things SQL Server query tuning, execution plans, and more. You\u2019ll hear about some of the problems Hugo\u2019s encountered during his consultancy career, what SQL Server has in common with a highway, and Hugo\u2019s thoughts on AI \u2013 plus much more.<\/p>\n\n\n\n<p>Find Hugo at&nbsp;<a href=\"https:\/\/sqlserverfast.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/sqlserverfast.com\/<\/a><\/p>\n\n\n\n<p>Listen or watch to every episode of the Redgate Simple Talk podcast at&nbsp;<a href=\"https:\/\/www.red-gate.com\/simple-talk\/podcasts\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/www.red-gate.com\/simple-talk\/podcasts\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Grant is joined by SQL Server veteran and long-time Microsoft MVP,\u00a0Hugo Kornelis, to talk all things SQL Server query tuning, execution plans, and more.&hellip;<\/p>\n","protected":false},"featured_media":111999,"template":"","tags":[4168,4170,4150,4151],"podcast_category":[159200],"podcast_season":[159361],"class_list":["post-111998","podcast","type-podcast","status-publish","has-post-thumbnail","hentry","tag-database","tag-database-administration","tag-sql","tag-sql-server","podcast_category-coffee-chats","podcast_season-season-3"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/podcast\/111998","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/podcast"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/podcast"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media\/111999"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=111998"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=111998"},{"taxonomy":"podcast_category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/podcast_category?post=111998"},{"taxonomy":"podcast_season","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/podcast_season?post=111998"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}