Erik Darling, Postmodern Mortician
Do you have nonclustered indexes that are over a terabyte? Identity columns nearing the integer maximum? Are you worried about how you’re going to maintain, backup, and consistency check these databases in a reasonable window? Are your drives old and running out of space? Drop me a line!
Talk nerdy to me:
- Managing VLDBs
- Environment optimization
- Query and index tuning
- T-SQL trickery
- Automating the awful parts of your day
- Heavily peated single malts
When I’m not teaching archery at Camp Ozar, you can find me attempting to have positive and functional relationships with: my wife and kid, science fiction, reasonably obscure synthesizer driven music, YouTube playlists of 80s commercials, my lucky server upgrade mustache, and barbell training.
You can also find me giving out books in exchange for correct trivia answers at SQL user groups.
1 Comment. Leave new
[…] Erik Darling was the inspiration for this next table, since he can never manage to get rowgroup elimination in his queries. The code below is designed to create segments that allow for pretty much no rowgroup elimination whatsoever: […]