1.0Denny Cherry & Associates Consultinghttps://www.dcac.comMonica Rathbunhttps://www.dcac.com/author/monicadcac-co/Coding Standards Gone Bad in SQL Server – Denny Cherry & Associates Consultingrich600338<blockquote class="wp-embedded-content" data-secret="rT3qb9jE03"><a href="https://www.dcac.com/2020/04/21/coding-standards-gone-bad-in-sql-server/">Coding Standards Gone Bad in SQL Server</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://www.dcac.com/2020/04/21/coding-standards-gone-bad-in-sql-server/embed/#?secret=rT3qb9jE03" width="600" height="338" title="“Coding Standards Gone Bad in SQL Server” — Denny Cherry & Associates Consulting" data-secret="rT3qb9jE03" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script>
/*! This file is auto-generated */
!function(d,l){"use strict";l.querySelector&&d.addEventListener&&"undefined"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i<o.length;i++)o[i].style.display="none";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute("style"),"height"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):"link"===t.message&&(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document);
</script>
Knowing your data is very important when it comes to writing code. Now I’ll admit that I am very far from being a developer, however as a DBA, I spend much of my day’s performance tuning code. In doing so, I get to see many ways code can introduce excess database reads., One of the most recent things I have come across has to do with NULLs. The environment I was working in had no default values in their table design, so it was riddled with NULL values. Over the years they had implemented coding standards to try and mitigate… Continue Readinghttps://i0.wp.com/sqlespresso.com/wp-content/uploads/2020/04/Wrong1.png?resize=399%2C489&ssl=1