Thanks for the feedback. IIRC correctly, PureStorage also makes it pretty easy to add on later.
As a bit of a sidebar and especially with SSDs, I tend to "over-provision". It's been worth every penny because there's never been a "holy crap! We're almost out of disk space!" moment and most people recommend over-provisioning SSDs for "life expectancy" purposes anyway.
An example of my over-provisioning even enters my personal life. After a decade of having an older laptop, I finally bought a new one. It has 32GB of RAM (couldn't get the model I wanted with 64GB), 2TB of NVME SSDs, and 1TB of spinning rust for backups and speed comparisons.
It cost me about 25% more than the standard offerings but I should be good for another decade or so and I don't have to worry so much about TempDB (which I frequently beat the hell out of) cutting a path in the carpet. 😀
is pronounced "ree-bar
" and is a "Modenism
" for R
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
"If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
"Change is inevitable... change for the better is not."
When you put the right degree of spin on it, the number 3|8
is also a glyph that describes the nature of a DBAs job. 😉
How to post code problems
Create a Tally Function (fnTally)