TSQL Index Mega-Query

This TSQL query returns a huge amount of useful information about indexes. You can see how much an index is used, how much space it is taking up, what columns are included, etc. It is a great first step towards … Continue reading

Why you shouldn’t play the lottery

Most people know that your chances of winning the lottery are astronomically small.  Yet this is only half the reason why you should invest elsewhere.    The other half is the amount of money you have to pay to receive those … Continue reading

On Beauty and Algorithms

Algorithmic beauty is the same as algorithmic usefulness.  Beauty is simplicity, beauty is elegance, and beauty is efficiency.  This blog is about solving problems of all kinds. Algorithms are much more than snippets of computer code.  A computer follows algorithms … Continue reading