Ever created an index where the hidden clustered index key was an intentional second sort key? Please don't.

How to make a query faster, using temp tables.

This 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...

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...