leemarkumAs a percentage, how much time do you as #DBAs spend fixing broken things versus doing project work to design and build something new to improve things?
Frank HenningerAbout 18 months into a new position and I've got the fires mostly out. My issue now is getting devs to fix the items I've raised in tickets. Things like incorrect #EntityFramework mappings to varchar columns. I spent most of the last week tracing the source of implicit conversions.
Anders Pedersen@osiris687 Just change all your datatypes to N's ;) Only half joking.
@arrowdrive Honestly, that was the solution at my last position. It should be the proper solution here to due to a global footprint. However, fixing the model mapping is less impactful than the downtime for datatype changes.
@osiris687 Usually true. Working on changing a column that has 1B records, and is a PK. Took 48 minutes in test (64 cores, 500+ GB ram). EEK.