We’ve all been there. You’ve got a query where the JOIN or WHERE predicate is not SARGable. You’ve read about how this can be a problem, and how bad it is for performance. Alas, you cannot change the query. Sometimes this reason is political, sometimes … [Read More]
Assume you have configured a transactional replication publisher, which is part of an availability group (AG). Now, you have an asynchronous secondary AG (or mirroring) replica that is offline. Perhaps this is a DR node, and you are doing patching or other planned maintenance on … [Read More]
In my last Thirsty Thursday post, I published my list of essential bar equipment for folks who are interested in making mixology their quarantine hobby. Hopefully these little detours from technology & career advice will help with your work-life harmony while we’re all working from … [Read More]
Stop shrinking your tempdb data files I recently wrote about growing, shrinking, and removing tempdb files. In that article I explained that SQL Server won’t move a page that contains an internal worktable object, and thus trying to shrink tempdb files can be futile. Today, … [Read More]
I recently came across a server where tempdb was breaking all the rules. Data files were all different sizes. I want all data files to be the same size so that proportional fill uses them evenly. There were 10 tempdb files, with 8 files on … [Read More]
I’m writing this post during the Coronavirus pandemic. Billions of people across the globe are isolating in their homes. Folks have started exploring new hobbies and interests as a way to pass the time and to keep their mind sharp. Folks are depending heavily on … [Read More]
There’s a lot of advice out there on the internet that suggests that you should not install SSMS on your database servers running SQL Server. This came up at work recently, where I was asked “Should we install SSMS on our database servers?” and my … [Read More]
Last week, I had the pleasure of participating in Redgate Streamed, a three-day virtual conference organized by my friends at Redgate. My session was Shortcuts from an impatient DBA–discussing a bunch of Management Studio tips & tricks for data professionals. The virtual conference was free … [Read More]
This morning, my friend Aaron Bertrand (blog|twitter) posted a plea for help with STRING_SPLIT() improvements. I’m very much in Aaron’s corner on this, having written about the olden days myself. Why STRING_SPLIT() is supposed to be awesome CLR was fast, but inaccessible to many DBAs. … [Read More]
I’m super excited to announce that today I was notified that I will be joining the Friends of Redgate program! 🎉💃🎊
Copyright © 2024 | Andy Mallon | am2.co