Browse the archive
Question I have came across several articles that mentioned that advise on not to store monetary value as decimal, but use integer instead. The reasoning that it does not store actual value and will cause some rounding difference/errors. But i have yet ever …
Continue readingThere 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 …
Continue readingI 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 …
Continue readingIn 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 I was doing, and keep sharing what I …
Continue readingLast night while having dinner with my husband, I had a thought and messaged Chrissy LeMaire (blog) 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 data queers to …
Continue readingWhat counts as downtime from a user’s perspective, beyond whether a server is technically online?
Continue readingStarting with SQL Server 2017 CU6 and SQL Server 2016 SP2-CU3, you can now configure your distribution database as part of an Availability Group (AG). I found one spot where a minor change made a few of my scripts blow up.
Continue readingYesterday, I talked about batching deletes, and the day before I talked about how much I like to delete data, and why it's necessary to do it, despite being a data pack rat. Today, let's look at just one scenario, and how I like to handle it. In my experience, …
Continue readingYesterday, I wrote about the importance of planning your data purges. Today, let's look at the simplest requirement for purging data: Keep data for X days after it's created.
Continue readingDBAs & Data professionals tend to be digital packrats. My personal Google Drive is filled with random files that I refused to part with--even though it's of questionable value. I lament that I do not have a copy of every paper I typed in high school or …
Continue reading
