@PaulWhite they aren't; plenty of unused and merge-able indexes around, but they were able to keep adding on to that point without cleaning up because there was nothing noticeable happening
the debate reminds me somewhat of the argument that heaps are 3-4x better than clustered indexes because lookups are direct rather than requiring a b-tree traversal
Speaking as someone who has implemented quite beautifully optimal designs to support kitchen-sink queries in the past, I wouldn't bother 90% of the time these days
If you're a startup, you don't have the money to pay experts. When you are successful, you focus on expansion and not tech debt. It's gotta take a near-death experience to make it a priority
@Zikato yes; this week i turned on rcsi and used query store to force serial plans for 3 queries rather than try to fix a bunch of bad design choices and dynamic orm queries
I get that from a consultant's perspective but from employee's perspective wouldn't you want to improve the design because you're gonna stick around for longer?
it's funny because the initial expectations were that CS storage would provide most of the benefit. in practice, most comes from RS batch mode ops on modern hardware
@ErikDarling I was at 3 companies that tried that instead of the refactoring. It's always called something like Phoenix or Lazarus. They hire double the people - the old guard to support the old platform and new ones to build the state-of-the-art.
i used to laugh at the bou folks for adding "in sql server" or spelling things out to the max but then i ended up going through 900+ posts on my site to add the same seo memes to headlines and post bodies etc
i was just listening to a podcast about how government hackers will find linkedin profiles of db/sys admins who work places they want to get into and then find forum posts by them asking for help with stuff to recon their infrastructure
they'll even answer questions for them in ways that make their domains unsafe
SQL Version: Microsoft SQL Server 2016(SP3)(KB5003279) - 13.0.6300.2 (X64)
OS Version: Windows Server 2012 R2 Standard
I am trying to setup the backups and database maintenance jobs using Ola Hallengren's sripts. I have the following job setup:
sqlcmd -E -S $(ESCAPE_SQUOTE(SRVR)) -d master -Q "
...