Max EmanuelssonSep 28, 20222 minHidden index keys might serve more of a purpose than you know. But they shouldn't.Ever created an index where the hidden clustered index key was an intentional second sort key? Please don't.
Max EmanuelssonApr 30, 20222 minHow to make a query faster, using temp tablesHow to make a query faster, using temp tables.
Max EmanuelssonMar 10, 20214 minMy performance tuning process and the power of computed columnsThis blog was never meant to go from point A to point Z in regards to difficulty or knowledge requirements. I just wanted to blog about...
Max EmanuelssonFeb 9, 20211 min"Not exists" is faster than "left outer join where is null"In case you didn't know, if you want to retrieve rows from a table that doesn't have a connection to another table, you can write a left...