There is a corner case where it makes sense to have a non-clustered index “duplicating” the clustered index. If you have a query that frequently scans the table, and ONLY makes use of the clustering key column, the query optimizer will prefer to use the non-clustered index.
I was recently chatting with a coworker, discussing why there is no discrete DROP permission for tables, procedures, etc. The conversation actually came from a #SQLHelp question on SQL Slack that was asked along the lines of “What if I want to let a user … [Read More]
When I started out blogging 5 years ago, there was a lot that I didn’t know. I figured things out as I went. The FreeCon helped give me a giant push in the right direction. But there are some things that nobody ever tells you. … [Read More]
In my last few posts, I’ve walked down memory lane, and talked about a ton of great successes I’ve had in my five years as blogger & speaker. It’s been fun to reminisce about how far I’ve come and brag about some success. Today’s post … [Read More]
In Year Three, I had a pretty big year. I kind of felt like I had peaked. I had received the Community Influencer of the Year Award and Microsoft MVP Award. Where do you go from there? Mostly, I just wanted to keep up what … [Read More]
In Year Three, my goal was to keep focused on what I learned in the FreeCon the year before, and keep moving forward with speaking and blogging. I was putting a bit more effort into my speaking (and thus easing off on the blogging some).
In Year 1, I only wrote 6 blog posts. In Year 2, I decided to take things seriously, and kicked things into high gear. During this 12-month period, I wrote 36 blog posts–my best 12-months as far as pace & productivity in these five years.
I’ve lost my blog stats for that first year, so I can’t say exactly how many visitors I had. I can say that the number of views was so low that it didn’t matter. If I were going to offer a generous estimate, I would guess I got whopping 100 page views in year one (mostly from me). I wrote a total of six blog posts that year. Let’s look at two of my favorites.
On May 16, 2014, I bought a domain on a whim. I’d been sitting in the NOCC at my employer, helping with maintenance. I was waiting on another team to perform their task, and champing at the bit. Over the next week, I set up a Blogger website, tied my domain to it, and thought about what I’d done at work recently that might be worth sharing.
Last night while having dinner with my husband, I had a thought and messaged Chrissy LeMaire (blog|twitter) on the SQL Server Community Slack. Thoughts on an LGBTQ channel here? I doubt it would be very active… But I’d love to have a spot for the … [Read More]
Copyright © 2023 | Andy Mallon | am2.co