Temporary Table Name Conflict

This was an error I encounted the other week at work and I thought it worth sharing as it’s a bit of a gotcha. You normally expect that temp tables are fine to share names across sessions since they are designed to be temporary. However, there are a few times when conflicts can occur. See this post on MSSQL Tips for more details. Basically, if we don’t do any of the things that disallow caching, then trying to re-use a temp table name in a “inner” called stored procedure will cause a conflict....

March 19, 2022

Personal Book Review: Stumbling on Happiness

This was an interesting book - not a guide to happiness as you might think at first, but an explanation of some of the psychological reasons why we are bad at predicting what will make us happy. He has some tips at the very end, but mostly it’s a jaunt through the interesting things our brain does to try to help us, and when those things can backfire. This is part review, part me-keeping-notes-for-the-future....

February 27, 2022

Personal Book Review: The Secret Life of Groceries

I thought I’d start making better notes on non-fiction books I read and post them here as a bit of a reminder to myself for lessons learnt, and a sort of tracker for interesting books I’ve read. Thankfully, the local library has quite a large selection. First is The Secret Life of Groceries: The Dark Miracle of the American Supermarket. This is one about the food supply chain in the US....

February 12, 2022

Clustered Index Uniquifier Overflow

I had an interesting problem at work the other day. One of our nightly ETL steps was returning this error: “The maximum system-generated unique value for a duplicate group was exceeded for index with partition ID . Dropping and re-creating the index may resolve this; otherwise, use another clustering key.” I admit it was something I had never seen before, so of course a quick trip to Google is in order....

February 8, 2022

Thoughts for 2022

Some of my thoughts for 2022 and what I want to get done: If I aim for a cello grade each year, my grade four exam will be coming up in May. However, my teacher has injured herself, and won’t be doing any more teaching this year. So, unless I can find a new teacher here on the Sunshine Coast, I know it will be difficult to pass this exam....

January 21, 2022