{"id":773,"date":"2024-01-02T23:42:11","date_gmt":"2024-01-02T22:42:11","guid":{"rendered":"https:\/\/people.iola.dk\/arj\/?p=773"},"modified":"2024-03-07T14:26:40","modified_gmt":"2024-03-07T13:26:40","slug":"sql-links","status":"publish","type":"post","link":"https:\/\/people.iola.dk\/arj\/2024\/01\/02\/sql-links\/","title":{"rendered":"SQL links"},"content":{"rendered":"\n<p>SQL sometimes feel a bit like <strong>black<\/strong> magic. How the query engine figures out what plan to execute, why is this query slow etc. The best resource I have come across is the book <a href=\"https:\/\/sqlfordevs.com\/ebooks\/indexing\" data-type=\"link\" data-id=\"https:\/\/sqlfordevs.com\/ebooks\/indexing\">Indexing beyond the basics<\/a>. Its available as a PDF download or for reading online. It gives a bit of easy to remember theory and lots of great examples. <\/p>\n\n\n\n<p>Some more random links I stumples upon recently:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.sqlshack.com\/query-optimization-techniques-in-sql-server-parameter-sniffing\/\" data-type=\"link\" data-id=\"https:\/\/www.sqlshack.com\/query-optimization-techniques-in-sql-server-parameter-sniffing\/\">Parameter sniffing<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/sqlperformance.com\/2017\/01\/t-sql-queries\/surprises-assumptions-group-by-distinct\" data-type=\"link\" data-id=\"https:\/\/sqlperformance.com\/2017\/01\/t-sql-queries\/surprises-assumptions-group-by-distinct\">Group versus distinct<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/databases\/sql-server\/t-sql-programming-sql-server\/dont-use-distinct-as-a-join-fixer\/\" data-type=\"link\" data-id=\"https:\/\/www.red-gate.com\/simple-talk\/databases\/sql-server\/t-sql-programming-sql-server\/dont-use-distinct-as-a-join-fixer\/\">Exists join<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/sqlperformance.com\/2016\/12\/sql-performance\/sql-server-v-next-string_agg-performance\" data-type=\"link\" data-id=\"https:\/\/sqlperformance.com\/2016\/12\/sql-performance\/sql-server-v-next-string_agg-performance\">String agg<\/a> <\/li>\n<\/ul>\n\n\n\n<p>And lastly ALWAYS remember to<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/people.iola.dk\/arj\/wp-content\/uploads\/E2PWVuWXsAUg3-j.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1514\" height=\"1270\" src=\"https:\/\/people.iola.dk\/arj\/wp-content\/uploads\/E2PWVuWXsAUg3-j.jpg\" alt=\"\" class=\"wp-image-774\"\/><\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>SQL sometimes feel a bit like black magic. How the query engine figures out what plan to execute, why is this query slow etc. The best resource I have come across is the book Indexing beyond the basics. Its available as a PDF download or for reading online. It gives a bit of easy to [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[308],"tags":[],"class_list":["post-773","post","type-post","status-publish","format-standard","hentry","category-blog"],"_links":{"self":[{"href":"https:\/\/people.iola.dk\/arj\/wp-json\/wp\/v2\/posts\/773","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/people.iola.dk\/arj\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/people.iola.dk\/arj\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/people.iola.dk\/arj\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/people.iola.dk\/arj\/wp-json\/wp\/v2\/comments?post=773"}],"version-history":[{"count":4,"href":"https:\/\/people.iola.dk\/arj\/wp-json\/wp\/v2\/posts\/773\/revisions"}],"predecessor-version":[{"id":805,"href":"https:\/\/people.iola.dk\/arj\/wp-json\/wp\/v2\/posts\/773\/revisions\/805"}],"wp:attachment":[{"href":"https:\/\/people.iola.dk\/arj\/wp-json\/wp\/v2\/media?parent=773"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/people.iola.dk\/arj\/wp-json\/wp\/v2\/categories?post=773"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/people.iola.dk\/arj\/wp-json\/wp\/v2\/tags?post=773"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}