env stands for Environment. I use it as a prefix + mnemonic to keep over 200 scripts at my fingertips.
If you read my “Invest In Yourself” post, I recommend throwing 30 euros at this incredible productivity too and buying the a license for SSMS Tools.
Inside that tool I can add a snippet, that when I type it in SQL Server Management Studio, it replaces the snippet and pastes literally thousands of lines of code that I had previously written.
envmissing – is the code I have developed over the years that lists the top missing index information. the code itself is parameterized so I can optionally limit it to a single table or pattern for a WHERE statement. The best part is, with all the statistics in my face, I can make an intelligent decision, and my code conveniently create the CREATE INDEX definition for me.